# Checking port 64770
# Found port 64770
Name: test
Data directory: /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/data/t_002_nonesuch_test_data/pgdata
Backup directory: /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/data/t_002_nonesuch_test_data/backup
Archive directory: /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/data/t_002_nonesuch_test_data/archives
Connection string: port=64770 host=/var/folders/xc/tpssff9959345bnqq4c6tlww0000gn/T/H877UA9JJl
Log file: /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/log/002_nonesuch_test.log
[20:34:39.146](0.014s) # initializing database system by copying initdb template
# Running: cp -RPp /Users/admin/pgsql/build/tmp_install/initdb-template /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/data/t_002_nonesuch_test_data/pgdata
# Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/data/t_002_nonesuch_test_data/pgdata
### Starting node "test"
# Running: pg_ctl -w -D /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/data/t_002_nonesuch_test_data/pgdata -l /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/log/002_nonesuch_test.log -o --cluster-name=test start
waiting for server to start.... done
server started
# Postmaster PID for node "test" is 25588
# Running: pg_amcheck qqq
[20:34:40.470](1.324s) ok 1 - checking a non-existent database status (got 1 vs expected 1)
[20:34:40.471](0.000s) ok 2 - checking a non-existent database stdout /(?^:^$)/
[20:34:40.471](0.000s) ok 3 - checking a non-existent database stderr /(?^:FATAL:  database "qqq" does not exist)/
# Running: pg_amcheck -d qqq -d postgres
[20:34:40.493](0.022s) ok 4 - checking an unresolvable database pattern status (got 1 vs expected 1)
[20:34:40.494](0.000s) ok 5 - checking an unresolvable database pattern stdout /(?^:^$)/
[20:34:40.494](0.000s) ok 6 - checking an unresolvable database pattern stderr /(?^:pg_amcheck: error: no connectable databases to check matching "qqq")/
# Running: pg_amcheck --no-strict-names -d qqq -d postgres
[20:34:40.711](0.217s) ok 7 - checking an unresolvable database pattern under --no-strict-names status (got 0 vs expected 0)
[20:34:40.711](0.001s) ok 8 - checking an unresolvable database pattern under --no-strict-names stdout /(?^:^$)/
[20:34:40.712](0.000s) ok 9 - checking an unresolvable database pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "qqq")/
# Running: pg_amcheck -d post -d postgres
[20:34:40.728](0.017s) ok 10 - checking an unresolvable database pattern (substring of existent database) status (got 1 vs expected 1)
[20:34:40.729](0.000s) ok 11 - checking an unresolvable database pattern (substring of existent database) stdout /(?^:^$)/
[20:34:40.729](0.000s) ok 12 - checking an unresolvable database pattern (substring of existent database) stderr /(?^:pg_amcheck: error: no connectable databases to check matching "post")/
# Running: pg_amcheck -d postgresql -d postgres
[20:34:40.744](0.015s) ok 13 - checking an unresolvable database pattern (superstring of existent database) status (got 1 vs expected 1)
[20:34:40.744](0.000s) ok 14 - checking an unresolvable database pattern (superstring of existent database) stdout /(?^:^$)/
[20:34:40.744](0.000s) ok 15 - checking an unresolvable database pattern (superstring of existent database) stderr /(?^:pg_amcheck: error: no connectable databases to check matching "postgresql")/
# Running: pg_amcheck -U no_such_user postgres
[20:34:40.759](0.015s) ok 16 - checking with a non-existent user status (got 1 vs expected 1)
[20:34:40.759](0.000s) ok 17 - checking with a non-existent user stdout /(?^:^$)/
# Running: pg_amcheck template1
[20:34:40.774](0.015s) ok 18 - checking a database by name without amcheck installed, no other databases status (got 1 vs expected 1)
[20:34:40.774](0.000s) ok 19 - checking a database by name without amcheck installed, no other databases stdout /(?^:^$)/
[20:34:40.775](0.000s) ok 20 - checking a database by name without amcheck installed, no other databases stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/
[20:34:40.775](0.000s) ok 21 - checking a database by name without amcheck installed, no other databases stderr /(?^:pg_amcheck: error: no relations to check)/
# Running: pg_amcheck -d template1 -d postgres
[20:34:40.906](0.131s) ok 22 - checking a database by name without amcheck installed, with other databases status (got 0 vs expected 0)
[20:34:40.906](0.000s) ok 23 - checking a database by name without amcheck installed, with other databases stdout /(?^:^$)/
[20:34:40.906](0.000s) ok 24 - checking a database by name without amcheck installed, with other databases stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/
# Running: pg_amcheck --all
[20:34:41.019](0.113s) ok 25 - checking a database by pattern without amcheck installed, with other databases status (got 0 vs expected 0)
[20:34:41.019](0.000s) ok 26 - checking a database by pattern without amcheck installed, with other databases stdout /(?^:^$)/
[20:34:41.019](0.000s) ok 27 - checking a database by pattern without amcheck installed, with other databases stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/
# Running: pg_amcheck -d postgres -t ..
[20:34:41.049](0.030s) ok 28 - checking table pattern ".." status (got 1 vs expected 1)
[20:34:41.049](0.000s) ok 29 - checking table pattern ".." stdout /(?^:^$)/
[20:34:41.049](0.000s) ok 30 - checking table pattern ".." stderr /(?^:pg_amcheck: error: no connectable databases to check matching "\.\.")/
# Running: pg_amcheck -d postgres -t .foo.bar
[20:34:41.078](0.029s) ok 31 - checking table pattern ".foo.bar" status (got 1 vs expected 1)
[20:34:41.078](0.000s) ok 32 - checking table pattern ".foo.bar" stdout /(?^:^$)/
[20:34:41.079](0.000s) ok 33 - checking table pattern ".foo.bar" stderr /(?^:pg_amcheck: error: no connectable databases to check matching "\.foo\.bar")/
# Running: pg_amcheck -d postgres -t .
[20:34:41.117](0.039s) ok 34 - checking table pattern "." status (got 1 vs expected 1)
[20:34:41.117](0.000s) ok 35 - checking table pattern "." stdout /(?^:^$)/
[20:34:41.117](0.000s) ok 36 - checking table pattern "." stderr /(?^:pg_amcheck: error: no heap tables to check matching "\.")/
# Running: pg_amcheck -d localhost.postgres
[20:34:41.135](0.017s) ok 37 - multipart database patterns are rejected status (got 2 vs expected 2)
[20:34:41.135](0.000s) ok 38 - multipart database patterns are rejected stdout /(?^:^$)/
[20:34:41.135](0.000s) ok 39 - multipart database patterns are rejected stderr /(?^:pg_amcheck: error: improper qualified name \(too many dotted names\): localhost\.postgres)/
# Running: pg_amcheck -s localhost.postgres.pg_catalog
[20:34:41.152](0.017s) ok 40 - three part schema patterns are rejected status (got 2 vs expected 2)
[20:34:41.152](0.001s) ok 41 - three part schema patterns are rejected stdout /(?^:^$)/
[20:34:41.153](0.000s) ok 42 - three part schema patterns are rejected stderr /(?^:pg_amcheck: error: improper qualified name \(too many dotted names\): localhost\.postgres\.pg_catalog)/
# Running: pg_amcheck -t localhost.postgres.pg_catalog.pg_class
[20:34:41.171](0.018s) ok 43 - four part table patterns are rejected status (got 2 vs expected 2)
[20:34:41.171](0.000s) ok 44 - four part table patterns are rejected stdout /(?^:^$)/
[20:34:41.171](0.000s) ok 45 - four part table patterns are rejected stderr /(?^:pg_amcheck: error: improper relation name \(too many dotted names\): localhost\.postgres\.pg_catalog\.pg_class)/
# Running: pg_amcheck --no-strict-names -t this.is.a.really.long.dotted.string
[20:34:41.188](0.017s) ok 46 - ungrammatical table names still draw errors under --no-strict-names status (got 2 vs expected 2)
[20:34:41.189](0.000s) ok 47 - ungrammatical table names still draw errors under --no-strict-names stdout /(?^:^$)/
[20:34:41.189](0.000s) ok 48 - ungrammatical table names still draw errors under --no-strict-names stderr /(?^:pg_amcheck: error: improper relation name \(too many dotted names\): this\.is\.a\.really\.long\.dotted\.string)/
# Running: pg_amcheck --no-strict-names -s postgres.long.dotted.string
[20:34:41.200](0.011s) ok 49 - ungrammatical schema names still draw errors under --no-strict-names status (got 2 vs expected 2)
[20:34:41.200](0.000s) ok 50 - ungrammatical schema names still draw errors under --no-strict-names stdout /(?^:^$)/
[20:34:41.200](0.000s) ok 51 - ungrammatical schema names still draw errors under --no-strict-names stderr /(?^:pg_amcheck: error: improper qualified name \(too many dotted names\): postgres\.long\.dotted\.string)/
# Running: pg_amcheck --no-strict-names -d postgres.long.dotted.string
[20:34:41.222](0.022s) ok 52 - ungrammatical database names still draw errors under --no-strict-names status (got 2 vs expected 2)
[20:34:41.222](0.000s) ok 53 - ungrammatical database names still draw errors under --no-strict-names stdout /(?^:^$)/
[20:34:41.222](0.000s) ok 54 - ungrammatical database names still draw errors under --no-strict-names stderr /(?^:pg_amcheck: error: improper qualified name \(too many dotted names\): postgres\.long\.dotted\.string)/
# Running: pg_amcheck --no-strict-names -T a.b.c.d
[20:34:41.246](0.024s) ok 55 - ungrammatical table exclusions still draw errors under --no-strict-names status (got 2 vs expected 2)
[20:34:41.247](0.000s) ok 56 - ungrammatical table exclusions still draw errors under --no-strict-names stdout /(?^:^$)/
[20:34:41.247](0.000s) ok 57 - ungrammatical table exclusions still draw errors under --no-strict-names stderr /(?^:pg_amcheck: error: improper relation name \(too many dotted names\): a\.b\.c\.d)/
# Running: pg_amcheck --no-strict-names -S a.b.c
[20:34:41.259](0.012s) ok 58 - ungrammatical schema exclusions still draw errors under --no-strict-names status (got 2 vs expected 2)
[20:34:41.260](0.001s) ok 59 - ungrammatical schema exclusions still draw errors under --no-strict-names stdout /(?^:^$)/
[20:34:41.260](0.000s) ok 60 - ungrammatical schema exclusions still draw errors under --no-strict-names stderr /(?^:pg_amcheck: error: improper qualified name \(too many dotted names\): a\.b\.c)/
# Running: pg_amcheck --no-strict-names -D a.b
[20:34:41.272](0.012s) ok 61 - ungrammatical database exclusions still draw errors under --no-strict-names status (got 2 vs expected 2)
[20:34:41.272](0.000s) ok 62 - ungrammatical database exclusions still draw errors under --no-strict-names stdout /(?^:^$)/
[20:34:41.272](0.000s) ok 63 - ungrammatical database exclusions still draw errors under --no-strict-names stderr /(?^:pg_amcheck: error: improper qualified name \(too many dotted names\): a\.b)/
# Running: pg_amcheck --no-strict-names -t no_such_table -t no*such*table -i no_such_index -i no*such*index -r no_such_relation -r no*such*relation -d no_such_database -d no*such*database -r none.none -r none.none.none -r postgres.none.none -r postgres.pg_catalog.none -r postgres.none.pg_class -t postgres.pg_catalog.pg_class
[20:34:41.314](0.042s) ok 64 - many unmatched patterns and one matched pattern under --no-strict-names status (got 0 vs expected 0)
[20:34:41.314](0.000s) ok 65 - many unmatched patterns and one matched pattern under --no-strict-names stdout /(?^:^$)/
[20:34:41.314](0.000s) ok 66 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no heap tables to check matching "no_such_table")/
[20:34:41.314](0.000s) ok 67 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no heap tables to check matching "no\*such\*table")/
[20:34:41.314](0.000s) ok 68 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no btree indexes to check matching "no_such_index")/
[20:34:41.314](0.000s) ok 69 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no btree indexes to check matching "no\*such\*index")/
[20:34:41.314](0.000s) ok 70 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no relations to check matching "no_such_relation")/
[20:34:41.314](0.000s) ok 71 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no relations to check matching "no\*such\*relation")/
[20:34:41.314](0.000s) ok 72 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no heap tables to check matching "no\*such\*table")/
[20:34:41.315](0.000s) ok 73 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "no_such_database")/
[20:34:41.315](0.000s) ok 74 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "no\*such\*database")/
[20:34:41.315](0.000s) ok 75 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no relations to check matching "none\.none")/
[20:34:41.315](0.000s) ok 76 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "none\.none\.none")/
[20:34:41.315](0.000s) ok 77 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no relations to check matching "postgres\.none\.none")/
[20:34:41.315](0.000s) ok 78 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no relations to check matching "postgres\.pg_catalog\.none")/
[20:34:41.315](0.000s) ok 79 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no relations to check matching "postgres\.none\.pg_class")/
[20:34:41.315](0.000s) ok 80 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "no_such_database")/
[20:34:41.315](0.000s) ok 81 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "no\*such\*database")/
[20:34:41.315](0.000s) ok 82 - many unmatched patterns and one matched pattern under --no-strict-names stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "none\.none\.none")/
# Running: pg_amcheck -d regression_invalid
[20:34:41.486](0.171s) ok 83 - checking handling of invalid database status (got 1 vs expected 1)
[20:34:41.487](0.000s) ok 84 - checking handling of invalid database stdout /(?^:^$)/
[20:34:41.487](0.000s) ok 85 - checking handling of invalid database stderr /(?^:pg_amcheck: error: no connectable databases to check matching "regression_invalid")/
# Running: pg_amcheck -d postgres -t regression_invalid.public.foo
[20:34:41.597](0.110s) ok 86 - checking handling of object in invalid database status (got 1 vs expected 1)
[20:34:41.598](0.000s) ok 87 - checking handling of object in invalid database stdout /(?^:^$)/
[20:34:41.598](0.000s) ok 88 - checking handling of object in invalid database stderr /(?^:pg_amcheck: error: no connectable databases to check matching "regression_invalid.public.foo")/
# Running: pg_amcheck -d postgres --no-strict-names -t template1.public.foo -t another_db.public.foo -t no_such_database.public.foo -i template1.public.foo_idx -i another_db.public.foo_idx -i no_such_database.public.foo_idx
[20:34:42.126](0.528s) ok 89 - checking otherwise existent objects in the wrong databases status (got 1 vs expected 1)
[20:34:42.126](0.000s) ok 90 - checking otherwise existent objects in the wrong databases stdout /(?^:^$)/
[20:34:42.126](0.000s) ok 91 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/
[20:34:42.126](0.000s) ok 92 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no heap tables to check matching "template1\.public\.foo")/
[20:34:42.126](0.000s) ok 93 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no heap tables to check matching "another_db\.public\.foo")/
[20:34:42.126](0.000s) ok 94 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "no_such_database\.public\.foo")/
[20:34:42.126](0.000s) ok 95 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no btree indexes to check matching "template1\.public\.foo_idx")/
[20:34:42.126](0.000s) ok 96 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no btree indexes to check matching "another_db\.public\.foo_idx")/
[20:34:42.126](0.000s) ok 97 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: warning: no connectable databases to check matching "no_such_database\.public\.foo_idx")/
[20:34:42.126](0.000s) ok 98 - checking otherwise existent objects in the wrong databases stderr /(?^:pg_amcheck: error: no relations to check)/
# Running: pg_amcheck --all --no-strict-names -S public -S pg_catalog -S pg_toast -S information_schema
[20:34:42.168](0.042s) ok 99 - schema exclusion patterns exclude all relations status (got 1 vs expected 1)
[20:34:42.168](0.000s) ok 100 - schema exclusion patterns exclude all relations stdout /(?^:^$)/
[20:34:42.168](0.000s) ok 101 - schema exclusion patterns exclude all relations stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/
[20:34:42.168](0.000s) ok 102 - schema exclusion patterns exclude all relations stderr /(?^:pg_amcheck: error: no relations to check)/
# Running: pg_amcheck --all --no-strict-names -s public -s pg_catalog -s pg_toast -s information_schema -t pg_catalog.pg_class -S*
[20:34:42.208](0.040s) ok 103 - schema exclusion pattern overrides all inclusion patterns status (got 1 vs expected 1)
[20:34:42.208](0.000s) ok 104 - schema exclusion pattern overrides all inclusion patterns stdout /(?^:^$)/
[20:34:42.208](0.000s) not ok 105 - schema exclusion pattern overrides all inclusion patterns stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/
[20:34:42.208](0.000s) #   Failed test 'schema exclusion pattern overrides all inclusion patterns stderr /(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)/'
#   at /Users/admin/pgsql/src/bin/pg_amcheck/t/002_nonesuch.pl line 383.
[20:34:42.208](0.000s) #                   'pg_amcheck: warning: skipping database "another_db": amcheck is not installed
# '
#     doesn't match '(?^:pg_amcheck: warning: skipping database "template1": amcheck is not installed)'
[20:34:42.209](0.000s) not ok 106 - schema exclusion pattern overrides all inclusion patterns stderr /(?^:pg_amcheck: error: no relations to check)/
[20:34:42.209](0.000s) #   Failed test 'schema exclusion pattern overrides all inclusion patterns stderr /(?^:pg_amcheck: error: no relations to check)/'
#   at /Users/admin/pgsql/src/bin/pg_amcheck/t/002_nonesuch.pl line 383.
[20:34:42.209](0.000s) #                   'pg_amcheck: warning: skipping database "another_db": amcheck is not installed
# '
#     doesn't match '(?^:pg_amcheck: error: no relations to check)'
[20:34:42.209](0.000s) 1..106
### Stopping node "test" using mode immediate
# Running: pg_ctl -D /Users/admin/pgsql/build/testrun/pg_amcheck/002_nonesuch/data/t_002_nonesuch_test_data/pgdata -m immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "test"
[20:34:42.321](0.112s) # Looks like you failed 2 tests of 106.