# Running: vacuumdb --help [17:41:07.520](0.103s) ok 1 - vacuumdb --help exit code 0 [17:41:07.521](0.000s) ok 2 - vacuumdb --help goes to stdout [17:41:07.521](0.000s) ok 3 - vacuumdb --help nothing to stderr [17:41:07.521](0.000s) ok 4 - vacuumdb --help maximum line length # Running: vacuumdb --version [17:41:07.553](0.032s) ok 5 - vacuumdb --version exit code 0 [17:41:07.554](0.001s) ok 6 - vacuumdb --version goes to stdout [17:41:07.555](0.001s) ok 7 - vacuumdb --version nothing to stderr # Running: vacuumdb --not-a-valid-option [17:41:07.627](0.072s) ok 8 - vacuumdb with invalid option nonzero exit code [17:41:07.628](0.001s) ok 9 - vacuumdb with invalid option prints error message # Checking port 51165 # Found port 51165 Name: main Data directory: C:\cirrus\build/testrun/scripts/100_vacuumdb\data/t_100_vacuumdb_main_data/pgdata Backup directory: C:\cirrus\build/testrun/scripts/100_vacuumdb\data/t_100_vacuumdb_main_data/backup Archive directory: C:\cirrus\build/testrun/scripts/100_vacuumdb\data/t_100_vacuumdb_main_data/archives Connection string: port=51165 host=C:/Windows/TEMP/OpJYGvaPmd Log file: C:\cirrus\build/testrun/scripts/100_vacuumdb\log/100_vacuumdb_main.log [17:41:07.655](0.027s) # initializing database system by copying initdb template # Running: robocopy /E /NJS /NJH /NFL /NDL /NP C:/cirrus/build/tmp_install/initdb-template C:\cirrus\build/testrun/scripts/100_vacuumdb\data/t_100_vacuumdb_main_data/pgdata # Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\build/testrun/scripts/100_vacuumdb\data/t_100_vacuumdb_main_data/pgdata ### Starting node "main" # Running: pg_ctl -w -D C:\cirrus\build/testrun/scripts/100_vacuumdb\data/t_100_vacuumdb_main_data/pgdata -l C:\cirrus\build/testrun/scripts/100_vacuumdb\log/100_vacuumdb_main.log -o --cluster-name=main start waiting for server to start.... done server started # Postmaster PID for node "main" is 988 # Running: vacuumdb postgres vacuumdb: vacuuming database "postgres" [17:41:09.826](2.171s) ok 10 - vacuumdb postgres exit code 0 [17:41:09.831](0.005s) ok 11 - SQL VACUUM run: SQL found in server log # Running: vacuumdb -f postgres vacuumdb: vacuuming database "postgres" [17:41:11.093](1.262s) ok 12 - vacuumdb -f postgres exit code 0 [17:41:11.097](0.003s) ok 13 - vacuumdb -f: SQL found in server log # Running: vacuumdb -F postgres vacuumdb: vacuuming database "postgres" [17:41:11.385](0.288s) ok 14 - vacuumdb -F postgres exit code 0 [17:41:11.386](0.001s) ok 15 - vacuumdb -F: SQL found in server log # Running: vacuumdb -zj2 postgres vacuumdb: vacuuming database "postgres" [17:41:11.783](0.397s) ok 16 - vacuumdb -zj2 postgres exit code 0 [17:41:11.785](0.002s) ok 17 - vacuumdb -zj2: SQL found in server log # Running: vacuumdb -Z postgres vacuumdb: vacuuming database "postgres" [17:41:12.205](0.420s) ok 18 - vacuumdb -Z postgres exit code 0 [17:41:12.207](0.001s) ok 19 - vacuumdb -Z: SQL found in server log # Running: vacuumdb --disable-page-skipping postgres vacuumdb: vacuuming database "postgres" [17:41:12.460](0.253s) ok 20 - vacuumdb --disable-page-skipping postgres exit code 0 [17:41:12.461](0.001s) ok 21 - vacuumdb --disable-page-skipping: SQL found in server log # Running: vacuumdb --skip-locked postgres vacuumdb: vacuuming database "postgres" [17:41:12.668](0.207s) ok 22 - vacuumdb --skip-locked postgres exit code 0 [17:41:12.671](0.003s) ok 23 - vacuumdb --skip-locked: SQL found in server log # Running: vacuumdb --skip-locked --analyze-only postgres vacuumdb: vacuuming database "postgres" [17:41:13.039](0.368s) ok 24 - vacuumdb --skip-locked --analyze-only postgres exit code 0 [17:41:13.040](0.001s) ok 25 - vacuumdb --skip-locked --analyze-only: SQL found in server log # Running: vacuumdb --analyze-only --disable-page-skipping postgres vacuumdb: error: cannot use the "disable-page-skipping" option when performing only analyze [17:41:13.103](0.063s) ok 26 - --analyze-only and --disable-page-skipping specified together # Running: vacuumdb --no-index-cleanup postgres vacuumdb: vacuuming database "postgres" [17:41:13.409](0.305s) ok 27 - vacuumdb --no-index-cleanup postgres exit code 0 [17:41:13.409](0.001s) ok 28 - vacuumdb --no-index-cleanup: SQL found in server log # Running: vacuumdb --analyze-only --no-index-cleanup postgres vacuumdb: error: cannot use the "no-index-cleanup" option when performing only analyze [17:41:13.447](0.037s) ok 29 - --analyze-only and --no-index-cleanup specified together # Running: vacuumdb --no-truncate postgres vacuumdb: vacuuming database "postgres" [17:41:13.727](0.280s) ok 30 - vacuumdb --no-truncate postgres exit code 0 [17:41:13.727](0.001s) ok 31 - vacuumdb --no-truncate: SQL found in server log # Running: vacuumdb --analyze-only --no-truncate postgres vacuumdb: error: cannot use the "no-truncate" option when performing only analyze [17:41:13.816](0.089s) ok 32 - --analyze-only and --no-truncate specified together # Running: vacuumdb --no-process-main postgres vacuumdb: vacuuming database "postgres" [17:41:14.208](0.392s) ok 33 - vacuumdb --no-process-main postgres exit code 0 [17:41:14.209](0.001s) ok 34 - vacuumdb --no-process-main: SQL found in server log # Running: vacuumdb --analyze-only --no-process-main postgres vacuumdb: error: cannot use the "no-process-main" option when performing only analyze [17:41:14.430](0.221s) ok 35 - --analyze-only and --no-process-main specified together # Running: vacuumdb --no-process-toast postgres vacuumdb: vacuuming database "postgres" [17:41:14.704](0.274s) ok 36 - vacuumdb --no-process-toast postgres exit code 0 [17:41:14.708](0.004s) ok 37 - vacuumdb --no-process-toast: SQL found in server log # Running: vacuumdb --analyze-only --no-process-toast postgres vacuumdb: error: cannot use the "no-process-toast" option when performing only analyze [17:41:14.802](0.093s) ok 38 - --analyze-only and --no-process-toast specified together # Running: vacuumdb -P 2 postgres vacuumdb: vacuuming database "postgres" [17:41:14.922](0.120s) ok 39 - vacuumdb -P 2 postgres exit code 0 [17:41:14.924](0.002s) ok 40 - vacuumdb -P 2: SQL found in server log # Running: vacuumdb -P 0 postgres vacuumdb: vacuuming database "postgres" [17:41:15.149](0.225s) ok 41 - vacuumdb -P 0 postgres exit code 0 [17:41:15.151](0.003s) ok 42 - vacuumdb -P 0: SQL found in server log # Running: vacuumdb -Z --table=pg_am dbname=template1 vacuumdb: vacuuming database "template1" [17:41:15.294](0.143s) ok 43 - vacuumdb with connection string # Running: vacuumdb -Zt pg_am;ABORT postgres vacuumdb: vacuuming database "postgres" vacuumdb: error: query failed: ERROR: relation "pg_am;abort" does not exist LINE 2: VALUES ('pg_am;ABORT'::pg_catalog.regclass, NULL::pg_catal... ^ vacuumdb: detail: Query was: WITH listed_objects (object_oid, column_list) AS ( VALUES ('pg_am;ABORT'::pg_catalog.regclass, NULL::pg_catalog.text) ) SELECT c.relname, ns.nspname, listed_objects.column_list FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace ns ON c.relnamespace OPERATOR(pg_catalog.=) ns.oid LEFT JOIN pg_catalog.pg_class t ON c.reltoastrelid OPERATOR(pg_catalog.=) t.oid LEFT JOIN listed_objects ON listed_objects.object_oid OPERATOR(pg_catalog.=) c.oid WHERE listed_objects.object_oid IS NOT NULL ORDER BY c.relpages DESC; [17:41:15.566](0.272s) ok 44 - trailing command in "-t", without COLUMNS # Running: vacuumdb -Zt pg_am(amname);ABORT postgres vacuumdb: vacuuming database "postgres" WARNING: there is no transaction in progress [17:41:15.793](0.228s) ok 45 - trailing command in "-t", with COLUMNS # Running: vacuumdb -Z --table="need""q(uot"(")x") postgres vacuumdb: vacuuming database "postgres" [17:41:16.092](0.298s) ok 46 - column list # Running: vacuumdb -Zt funcidx postgres vacuumdb: vacuuming database "postgres" vacuumdb: error: processing of database "postgres" failed: ERROR: function f0(integer) does not exist LINE 1: SELECT f0($1) ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. QUERY: SELECT f0($1) CONTEXT: SQL function "f1" during inlining [17:41:16.225](0.133s) ok 47 - unqualified name via functional index # Running: vacuumdb --analyze --table vactable(c) postgres vacuumdb: vacuuming database "postgres" vacuumdb: error: processing of database "postgres" failed: ERROR: column "c" of relation "vactable" does not exist [17:41:16.388](0.163s) ok 48 - incorrect column name with ANALYZE # Running: vacuumdb -P -1 postgres vacuumdb: error: -P/--parallel must be in range 0..2147483647 [17:41:16.430](0.043s) ok 49 - negative parallel degree # Running: vacuumdb --analyze --table vactable(a, b) postgres vacuumdb: vacuuming database "postgres" [17:41:16.495](0.065s) ok 50 - vacuumdb --analyze --table vactable(a, b) postgres exit code 0 [17:41:16.499](0.004s) ok 51 - vacuumdb --analyze with complete column list: SQL found in server log # Running: vacuumdb --analyze-only --table vactable(b) postgres vacuumdb: vacuuming database "postgres" [17:41:16.613](0.113s) ok 52 - vacuumdb --analyze-only --table vactable(b) postgres exit code 0 [17:41:16.613](0.001s) ok 53 - vacuumdb --analyze-only with partial column list: SQL found in server log # Running: vacuumdb --analyze --table vacview postgres [17:41:16.762](0.149s) ok 54 - vacuumdb with view status (got 0 vs expected 0) [17:41:16.763](0.000s) ok 55 - vacuumdb with view stdout /(?^:^.*vacuuming database "postgres")/ [17:41:16.763](0.000s) ok 56 - vacuumdb with view stderr /(?^s:^WARNING.*cannot vacuum non-tables or special system tables)/ # Running: vacuumdb --table vactable --min-mxid-age 0 postgres vacuumdb: error: --min-mxid-age must be in range 1..2147483647 [17:41:16.816](0.053s) ok 57 - vacuumdb --min-mxid-age with incorrect value # Running: vacuumdb --table vactable --min-xid-age 0 postgres vacuumdb: error: --min-xid-age must be in range 1..2147483647 [17:41:16.882](0.066s) ok 58 - vacuumdb --min-xid-age with incorrect value # Running: vacuumdb --table vactable --min-mxid-age 2147483000 postgres vacuumdb: vacuuming database "postgres" [17:41:17.045](0.163s) ok 59 - vacuumdb --table vactable --min-mxid-age 2147483000 postgres exit code 0 [17:41:17.048](0.003s) ok 60 - vacuumdb --table --min-mxid-age: SQL found in server log # Running: vacuumdb --min-xid-age 2147483001 postgres vacuumdb: vacuuming database "postgres" [17:41:17.277](0.229s) ok 61 - vacuumdb --min-xid-age 2147483001 postgres exit code 0 [17:41:17.278](0.001s) ok 62 - vacuumdb --table --min-xid-age: SQL found in server log # Running: vacuumdb --schema "Foo" postgres vacuumdb: vacuuming database "postgres" [17:41:17.409](0.131s) ok 63 - vacuumdb --schema "Foo" postgres exit code 0 [17:41:17.410](0.001s) ok 64 - vacuumdb --schema: SQL found in server log # Running: vacuumdb --schema "Foo" --schema "Bar" postgres vacuumdb: vacuuming database "postgres" [17:41:17.496](0.086s) ok 65 - vacuumdb --schema "Foo" --schema "Bar" postgres exit code 0 [17:41:17.497](0.001s) ok 66 - vacuumdb multiple --schema switches: SQL found in server log # Running: vacuumdb --exclude-schema "Foo" postgres vacuumdb: vacuuming database "postgres" [17:41:17.733](0.236s) ok 67 - vacuumdb --exclude-schema "Foo" postgres exit code 0 [17:41:17.734](0.001s) not ok 68 - vacuumdb --exclude-schema: SQL found in server log [17:41:17.734](0.000s) # Failed test 'vacuumdb --exclude-schema: SQL found in server log' # at C:/cirrus/src/bin/scripts/t/100_vacuumdb.pl line 170. [17:41:17.735](0.001s) # '2024-02-19 17:41:17.464 GMT [6924][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-19 17:41:17.466 GMT [6924][client backend] [[unknown]][3/3117:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/100_vacuumdb/data/t_100_vacuumdb_main_data/pgdata/pg_hba.conf:117) # 2024-02-19 17:41:17.466 GMT [6924][client backend] [[unknown]][3/3117:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=100_vacuumdb.pl # 2024-02-19 17:41:17.470 GMT [6924][client backend] [100_vacuumdb.pl][3/3118:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); # 2024-02-19 17:41:17.471 GMT [6924][client backend] [100_vacuumdb.pl][3/3119:0] LOG: statement: RESET search_path; # 2024-02-19 17:41:17.471 GMT [6924][client backend] [100_vacuumdb.pl][3/3120:0] LOG: statement: WITH listed_objects (object_oid, column_list) AS ( # VALUES ('"Foo"'::pg_catalog.regnamespace, NULL::pg_catalog.text), # ('"Bar"'::pg_catalog.regnamespace, NULL::pg_catalog.text) # ) # SELECT c.relname, ns.nspname, listed_objects.column_list FROM pg_catalog.pg_class c # JOIN pg_catalog.pg_namespace ns ON c.relnamespace OPERATOR(pg_catalog.=) ns.oid # LEFT JOIN pg_catalog.pg_class t ON c.reltoastrelid OPERATOR(pg_catalog.=) t.oid # LEFT JOIN listed_objects ON listed_objects.object_oid OPERATOR(pg_catalog.=) ns.oid # WHERE listed_objects.object_oid IS NOT NULL # AND c.relkind OPERATOR(pg_catalog.=) ANY (array['r', 'm']) # ORDER BY c.relpages DESC; # 2024-02-19 17:41:17.477 GMT [6924][client backend] [100_vacuumdb.pl][3/3121:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); # 2024-02-19 17:41:17.477 GMT [6924][client backend] [100_vacuumdb.pl][3/3122:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) "Foo".bar; # 2024-02-19 17:41:17.478 GMT [6924][client backend] [100_vacuumdb.pl][3/3125:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) "Bar".baz; # 2024-02-19 17:41:17.478 GMT [6924][client backend] [100_vacuumdb.pl][3/3128:0] LOG: statement: VACUUM (ONLY_DATABASE_STATS); # 2024-02-19 17:41:17.479 GMT [6924][client backend] [100_vacuumdb.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] # 2024-02-19 17:41:17.532 GMT [2936][not initialized] [[unknown]][:0] LOG: connection received: host=[local] # 2024-02-19 17:41:17.533 GMT [2936][client backend] [[unknown]][3/3130:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/scripts/100_vacuumdb/data/t_100_vacuumdb_main_data/pgdata/pg_hba.conf:117) # 2024-02-19 17:41:17.533 GMT [2936][client backend] [[unknown]][3/3130:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=100_vacuumdb.pl # 2024-02-19 17:41:17.536 GMT [2936][client backend] [100_vacuumdb.pl][3/3131:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); # 2024-02-19 17:41:17.536 GMT [2936][client backend] [100_vacuumdb.pl][3/3132:0] LOG: statement: RESET search_path; # 2024-02-19 17:41:17.536 GMT [2936][client backend] [100_vacuumdb.pl][3/3133:0] LOG: statement: WITH listed_objects (object_oid, column_list) AS ( # VALUES ('"Foo"'::pg_catalog.regnamespace, NULL::pg_catalog.text) # ) # SELECT c.relname, ns.nspname, listed_objects.column_list FROM pg_catalog.pg_class c # JOIN pg_catalog.pg_namespace ns ON c.relnamespace OPERATOR(pg_catalog.=) ns.oid # LEFT JOIN pg_catalog.pg_class t ON c.reltoastrelid OPERATOR(pg_catalog.=) t.oid # LEFT JOIN listed_objects ON listed_objects.object_oid OPERATOR(pg_catalog.=) ns.oid # WHERE listed_objects.object_oid IS NULL # AND c.relkind OPERATOR(pg_catalog.=) ANY (array['r', 'm']) # ORDER BY c.relpages DESC; # 2024-02-19 17:41:17.543 GMT [2936][client backend] [100_vacuumdb.pl][3/3134:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); # 2024-02-19 17:41:17.543 GMT [2936][client backend] [100_vacuumdb.pl][3/3135:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_proc; # 2024-02-19 17:41:17.585 GMT [2936][client backend] [100_vacuumdb.pl][3/3139:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_attribute; # 2024-02-19 17:41:17.587 GMT [2936][client backend] [100_vacuumdb.pl][3/3142:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_description; # 2024-02-19 17:41:17.588 GMT [2936][client backend] [100_vacuumdb.pl][3/3146:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_statistic; # 2024-02-19 17:41:17.590 GMT [2936][client backend] [100_vacuumdb.pl][3/3150:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_collation; # 2024-02-19 17:41:17.591 GMT [2936][client backend] [100_vacuumdb.pl][3/3154:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_type; # 2024-02-19 17:41:17.593 GMT [2936][client backend] [100_vacuumdb.pl][3/3158:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_operator; # 2024-02-19 17:41:17.594 GMT [2936][client backend] [100_vacuumdb.pl][3/3161:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_rewrite; # 2024-02-19 17:41:17.601 GMT [2936][client backend] [100_vacuumdb.pl][3/3165:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_depend; # 2024-02-19 17:41:17.602 GMT [2936][client backend] [100_vacuumdb.pl][3/3168:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_class; # 2024-02-19 17:41:17.603 GMT [2936][client backend] [100_vacuumdb.pl][3/3171:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) information_schema.sql_features; # 2024-02-19 17:41:17.604 GMT [2936][client backend] [100_vacuumdb.pl][3/3175:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_amop; # 2024-02-19 17:41:17.605 GMT [2936][client backend] [100_vacuumdb.pl][3/3178:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_amproc; # 2024-02-19 17:41:17.606 GMT [2936][client backend] [100_vacuumdb.pl][3/3181:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_index; # 2024-02-19 17:41:17.606 GMT [2936][client backend] [100_vacuumdb.pl][3/3184:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_opclass; # 2024-02-19 17:41:17.607 GMT [2936][client backend] [100_vacuumdb.pl][3/3187:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_init_privs; # 2024-02-19 17:41:17.608 GMT [2936][client backend] [100_vacuumdb.pl][3/3191:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_constraint; # 2024-02-19 17:41:17.610 GMT [2936][client backend] [100_vacuumdb.pl][3/3195:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_ts_config_map; # 2024-02-19 17:41:17.610 GMT [2936][client backend] [100_vacuumdb.pl][3/3198:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_conversion; # 2024-02-19 17:41:17.611 GMT [2936][client backend] [100_vacuumdb.pl][3/3201:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_aggregate; # 2024-02-19 17:41:17.612 GMT [2936][client backend] [100_vacuumdb.pl][3/3205:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_opfamily; # 2024-02-19 17:41:17.612 GMT [2936][client backend] [100_vacuumdb.pl][3/3208:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_cast; # 2024-02-19 17:41:17.613 GMT [2936][client backend] [100_vacuumdb.pl][3/3211:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) information_schema.sql_sizing; # 2024-02-19 17:41:17.614 GMT [2936][client backend] [100_vacuumdb.pl][3/3215:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_authid; # 2024-02-19 17:41:17.615 GMT [2936][client backend] [100_vacuumdb.pl][3/3219:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_range; # 2024-02-19 17:41:17.615 GMT [2936][client backend] [100_vacuumdb.pl][3/3222:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_extension; # 2024-02-19 17:41:17.616 GMT [2936][client backend] [100_vacuumdb.pl][3/3226:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_ts_template; # 2024-02-19 17:41:17.617 GMT [2936][client backend] [100_vacuumdb.pl][3/3229:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_ts_parser; # 2024-02-19 17:41:17.618 GMT [2936][client backend] [100_vacuumdb.pl][3/3232:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_shdescription; # 2024-02-19 17:41:17.618 GMT [2936][client backend] [100_vacuumdb.pl][3/3236:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_am; # 2024-02-19 17:41:17.619 GMT [2936][client backend] [100_vacuumdb.pl][3/3239:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_language; # 2024-02-19 17:41:17.620 GMT [2936][client backend] [100_vacuumdb.pl][3/3243:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_namespace; # 2024-02-19 17:41:17.621 GMT [2936][client backend] [100_vacuumdb.pl][3/3247:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_database; # 2024-02-19 17:41:17.621 GMT [2936][client backend] [100_vacuumdb.pl][3/3251:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_ts_dict; # 2024-02-19 17:41:17.622 GMT [2936][client backend] [100_vacuumdb.pl][3/3255:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_tablespace; # 2024-02-19 17:41:17.623 GMT [2936][client backend] [100_vacuumdb.pl][3/3259:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_auth_members; # 2024-02-19 17:41:17.624 GMT [2936][client backend] [100_vacuumdb.pl][3/3262:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_ts_config; # 2024-02-19 17:41:17.625 GMT [2936][client backend] [100_vacuumdb.pl][3/3265:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) public.funcidx; # 2024-02-19 17:41:17.626 GMT [2936][client backend] [100_vacuumdb.pl][3/3268:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) information_schema.sql_parts; # 2024-02-19 17:41:17.627 GMT [2936][client backend] [100_vacuumdb.pl][3/3272:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) information_schema.sql_implementation_info; # 2024-02-19 17:41:17.628 GMT [2936][client backend] [100_vacuumdb.pl][3/3276:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) "Bar".baz; # 2024-02-19 17:41:17.629 GMT [2936][client backend] [100_vacuumdb.pl][3/3279:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_foreign_table; # 2024-02-19 17:41:17.629 GMT [2936][client backend] [100_vacuumdb.pl][3/3283:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_statistic_ext_data; # 2024-02-19 17:41:17.630 GMT [2936][client backend] [100_vacuumdb.pl][3/3287:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_user_mapping; # 2024-02-19 17:41:17.631 GMT [2936][client backend] [100_vacuumdb.pl][3/3291:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_subscription; # 2024-02-19 17:41:17.631 GMT [2936][client backend] [100_vacuumdb.pl][3/3295:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_attrdef; # 2024-02-19 17:41:17.633 GMT [2936][client backend] [100_vacuumdb.pl][3/3299:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_inherits; # 2024-02-19 17:41:17.633 GMT [2936][client backend] [100_vacuumdb.pl][3/3302:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_largeobject_metadata; # 2024-02-19 17:41:17.634 GMT [2936][client backend] [100_vacuumdb.pl][3/3305:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_statistic_ext; # 2024-02-19 17:41:17.634 GMT [2936][client backend] [100_vacuumdb.pl][3/3309:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_trigger; # 2024-02-19 17:41:17.635 GMT [2936][client backend] [100_vacuumdb.pl][3/3313:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_event_trigger; # 2024-02-19 17:41:17.636 GMT [2936][client backend] [100_vacuumdb.pl][3/3317:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_enum; # 2024-02-19 17:41:17.637 GMT [2936][client backend] [100_vacuumdb.pl][3/3320:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_db_role_setting; # 2024-02-19 17:41:17.638 GMT [2936][client backend] [100_vacuumdb.pl][3/3324:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_shdepend; # 2024-02-19 17:41:17.638 GMT [2936][client backend] [100_vacuumdb.pl][3/3327:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_publication; # 2024-02-19 17:41:17.639 GMT [2936][client backend] [100_vacuumdb.pl][3/3330:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_foreign_data_wrapper; # 2024-02-19 17:41:17.640 GMT [2936][client backend] [100_vacuumdb.pl][3/3334:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_foreign_server; # 2024-02-19 17:41:17.640 GMT [2936][client backend] [100_vacuumdb.pl][3/3338:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_policy; # 2024-02-19 17:41:17.641 GMT [2936][client backend] [100_vacuumdb.pl][3/3342:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_replication_origin; # 2024-02-19 17:41:17.642 GMT [2936][client backend] [100_vacuumdb.pl][3/3346:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_default_acl; # 2024-02-19 17:41:17.643 GMT [2936][client backend] [100_vacuumdb.pl][3/3350:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_seclabel; # 2024-02-19 17:41:17.644 GMT [2936][client backend] [100_vacuumdb.pl][3/3354:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_shseclabel; # 2024-02-19 17:41:17.645 GMT [2936][client backend] [100_vacuumdb.pl][3/3358:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_parameter_acl; # 2024-02-19 17:41:17.645 GMT [2936][client backend] [100_vacuumdb.pl][3/3362:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_partitioned_table; # 2024-02-19 17:41:17.647 GMT [2936][client backend] [100_vacuumdb.pl][3/3366:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_transform; # 2024-02-19 17:41:17.647 GMT [2936][client backend] [100_vacuumdb.pl][3/3369:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_sequence; # 2024-02-19 17:41:17.648 GMT [2936][client backend] [100_vacuumdb.pl][3/3372:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_publication_namespace; # 2024-02-19 17:41:17.648 GMT [2936][client backend] [100_vacuumdb.pl][3/3375:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_publication_rel; # 2024-02-19 17:41:17.649 GMT [2936][client backend] [100_vacuumdb.pl][3/3379:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_subscription_rel; # 2024-02-19 17:41:17.650 GMT [2936][client backend] [100_vacuumdb.pl][3/3382:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) pg_catalog.pg_largeobject; # 2024-02-19 17:41:17.650 GMT [2936][client backend] [100_vacuumdb.pl][3/3385:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) public."need""q(uot"; # 2024-02-19 17:41:17.651 GMT [2936][client backend] [100_vacuumdb.pl][3/3389:0] LOG: statement: VACUUM (SKIP_DATABASE_STATS) public.vactable; # 2024-02-19 17:41:17.651 GMT [2936][client backend] [100_vacuumdb.pl][3/3392:0] LOG: statement: VACUUM (ONLY_DATABASE_STATS); # 2024-02-19 17:41:17.652 GMT [2936][client backend] [100_vacuumdb.pl][:0] LOG: disconnection: session time: 0:00:00.123 user=SYSTEM database=postgres host=[local] # ' # doesn't match '(?^s:^(?!.*VACUUM \(SKIP_DATABASE_STATS\) "Foo".bar).*$)' # Running: vacuumdb --exclude-schema "Foo" --exclude-schema "Bar" postgres vacuumdb: vacuuming database "postgres" [17:41:17.999](0.265s) ok 69 - vacuumdb --exclude-schema "Foo" --exclude-schema "Bar" postgres exit code 0 [17:41:18.007](0.008s) ok 70 - vacuumdb multiple --exclude-schema switches: SQL found in server log # Running: vacuumdb -N pg_catalog -t pg_class postgres [17:41:18.093](0.086s) ok 71 - cannot use options -N and -t at the same time: exit code not 0 [17:41:18.093](0.000s) ok 72 - cannot use options -N and -t at the same time: matches # Running: vacuumdb -n pg_catalog -t pg_class postgres [17:41:18.163](0.069s) ok 73 - cannot use options -n and -t at the same time: exit code not 0 [17:41:18.163](0.000s) ok 74 - cannot use options -n and -t at the same time: matches # Running: vacuumdb -n pg_catalog -N "Foo" postgres [17:41:18.359](0.196s) ok 75 - cannot use options -n and -N at the same time: exit code not 0 [17:41:18.359](0.000s) ok 76 - cannot use options -n and -N at the same time: matches # Running: vacuumdb -a -N "Foo" [17:41:18.539](0.180s) ok 77 - cannot use options -a and -N at the same time: exit code not 0 [17:41:18.540](0.000s) ok 78 - cannot use options -a and -N at the same time: matches # Running: vacuumdb -a -n "Foo" [17:41:18.716](0.177s) ok 79 - cannot use options -a and -n at the same time: exit code not 0 [17:41:18.717](0.000s) ok 80 - cannot use options -a and -n at the same time: matches # Running: vacuumdb -a -t "Foo".bar [17:41:18.850](0.133s) ok 81 - cannot use options -a and -t at the same time: exit code not 0 [17:41:18.850](0.001s) ok 82 - cannot use options -a and -t at the same time: matches # Running: vacuumdb -a -d postgres [17:41:18.984](0.134s) ok 83 - cannot use options -a and -d at the same time: exit code not 0 [17:41:18.985](0.001s) ok 84 - cannot use options -a and -d at the same time: matches # Running: vacuumdb -a postgres [17:41:19.111](0.127s) ok 85 - cannot use option -a and a dbname as argument at the same time: exit code not 0 [17:41:19.112](0.001s) ok 86 - cannot use option -a and a dbname as argument at the same time: matches [17:41:19.114](0.002s) 1..86 ### Stopping node "main" using mode immediate # Running: pg_ctl -D C:\cirrus\build/testrun/scripts/100_vacuumdb\data/t_100_vacuumdb_main_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "main" [17:41:19.428](0.314s) # Looks like you failed 1 test of 86.