# Checking port 22240 # Found port 22240 Name: primary Version: 19devel Data directory: /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata Backup directory: /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/backup Archive directory: /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/archives Connection string: port=22240 host=/tmp/Ds5PGVm0S8 Log file: /home/postgres/postgres/build/testrun/recovery/027_stream_regress/log/027_stream_regress_primary.log [05:29:26.315](0.044s) # initializing database system by copying initdb template # Running: cp -RPp /home/postgres/postgres/build/tmp_install/initdb-template /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata # Running: /home/postgres/postgres/build/src/test/regress/pg_regress --config-auth /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata ### Starting node "primary" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata --log /home/postgres/postgres/build/testrun/recovery/027_stream_regress/log/027_stream_regress_primary.log --options --cluster-name=primary start waiting for server to start.... done server started # Postmaster PID for node "primary" is 86399 (standby_1,) [05:29:26.784](0.469s) ok 1 - physical slot created on primary # Taking pg_basebackup my_backup from node "primary" # Running: pg_basebackup --no-sync --pgdata /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/backup/my_backup --host /tmp/Ds5PGVm0S8 --port 22240 --checkpoint fast # Backup finished # Checking port 22241 # Found port 22241 Name: standby_1 Version: 19devel Data directory: /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/pgdata Backup directory: /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/backup Archive directory: /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/archives Connection string: port=22241 host=/tmp/Ds5PGVm0S8 Log file: /home/postgres/postgres/build/testrun/recovery/027_stream_regress/log/027_stream_regress_standby_1.log # Initializing node "standby_1" from backup "my_backup" of node "primary" ### Enabling streaming replication for node "standby_1" ### Starting node "standby_1" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/pgdata --log /home/postgres/postgres/build/testrun/recovery/027_stream_regress/log/027_stream_regress_standby_1.log --options --cluster-name=standby_1 start waiting for server to start.... done server started # Postmaster PID for node "standby_1" is 86107 # Running: /home/postgres/postgres/build/src/test/regress/pg_regress --dlpath=/home/postgres/postgres/build/src/test/regress --bindir= --host=/tmp/Ds5PGVm0S8 --port=22240 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/home/postgres/postgres/build/testrun/recovery/027_stream_regress/data [05:33:09.150](222.366s) not ok 2 - regression tests pass [05:33:09.151](0.001s) # Failed test 'regression tests pass' # at /home/postgres/postgres/src/test/recovery/t/027_stream_regress.pl line 74. [05:33:09.151](0.000s) # ---------- command failed ---------- [05:33:09.152](0.000s) # /home/postgres/postgres/build/src/test/regress/pg_regress --dlpath=/home/postgres/postgres/build/src/test/regress --bindir= --host=/tmp/Ds5PGVm0S8 --port=22240 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/home/postgres/postgres/build/testrun/recovery/027_stream_regress/data [05:33:09.152](0.000s) # -------------- stdout -------------- [05:33:09.152](0.000s) # # using postmaster on /tmp/Ds5PGVm0S8, port 22240 # ok 1 - test_setup 3741 ms # # parallel group (20 tests): varchar char pg_lsn oid text int2 name txid money boolean float4 int4 bit regproc int8 uuid float8 enum rangetypes numeric # ok 2 + boolean 1000 ms # ok 3 + char 375 ms # ok 4 + name 875 ms # ok 5 + varchar 354 ms # ok 6 + text 668 ms # ok 7 + int2 775 ms # ok 8 + int4 1009 ms # ok 9 + int8 1083 ms # ok 10 + oid 563 ms # ok 11 + float4 968 ms # ok 12 + float8 1121 ms # ok 13 + bit 1038 ms # ok 14 + numeric 3145 ms # ok 15 + txid 875 ms # ok 16 + uuid 1086 ms # ok 17 + enum 1141 ms # ok 18 + money 950 ms # ok 19 + rangetypes 2887 ms # ok 20 + pg_lsn 518 ms # ok 21 + regproc 1057 ms # # parallel group (20 tests): md5 path lseg circle macaddr line time macaddr8 point numerology timetz inet date timestamp interval timestamptz strings box polygon multirangetypes # ok 22 + strings 2345 ms # ok 23 + md5 166 ms # ok 24 + numerology 642 ms # ok 25 + point 541 ms # ok 26 + lseg 225 ms # ok 27 + line 333 ms [05:33:09.152](0.000s) # ... 207 lines omitted ... [05:33:09.153](0.000s) # ok 220 + partition_merge 9702 ms # ok 221 + partition_split 13239 ms # ok 222 + partition_join 12347 ms # ok 223 + partition_prune 10372 ms # ok 224 + reloptions 2169 ms # ok 225 + hash_part 1293 ms # ok 226 + indexing 18079 ms # ok 227 + partition_aggregate 7261 ms # ok 228 + partition_info 1331 ms # ok 229 + tuplesort 6449 ms # ok 230 + explain 1692 ms # ok 231 + memoize 7711 ms # ok 232 + stats 9675 ms # ok 233 + predicate 2106 ms # ok 234 + numa 247 ms # ok 235 + eager_aggregate 3666 ms # ok 236 + graph_table_rls 3365 ms # ok 237 + planner_est 1083 ms # # parallel group (4 tests): compression_pglz compression compression_lz4 cluster # ok 238 + compression 1880 ms # ok 239 + compression_lz4 2353 ms # ok 240 + compression_pglz 209 ms # ok 241 + cluster 4559 ms # # parallel group (2 tests): oidjoins event_trigger # ok 242 + oidjoins 4787 ms # ok 243 + event_trigger 5050 ms # ok 244 - event_trigger_login 272 ms # ok 245 - fast_default 1702 ms # ok 246 - tablespace 3859 ms # 1..246 [05:33:09.153](0.000s) # -------------- stderr -------------- [05:33:09.153](0.000s) # # diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out # # --- /home/postgres/postgres/src/test/regress/expected/goo.out Wed May 6 05:25:03 2026 # # +++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out Wed May 6 05:31:17 2026 # # @@ -139,8 +139,8 @@ # # JOIN dim3 ON fact.dim3_id = dim3.id # # JOIN dim4 ON fact.dim4_id = dim4.id # # WHERE dim1.id < 5; # # - QUERY PLAN # # ---------------------------------------------------------------------- # # + QUERY PLAN # # +--------------------------------------------------------------------------- # # Aggregate # # -> Nested Loop # # Join Filter: (fact.dim4_id = dim4.id) # # @@ -149,15 +149,15 @@ # # -> Seq Scan on dim3 # # -> Hash # # -> Hash Join # # - Hash Cond: (fact.dim1_id = dim1.id) # # - -> Hash Join # # - Hash Cond: (fact.dim2_id = dim2.id) # # - -> Seq Scan on fact # # - -> Hash # # - -> Seq Scan on dim2 # # + Hash Cond: (dim2.id = fact.dim2_id) # # + -> Seq Scan on dim2 # # -> Hash # # - -> Seq Scan on dim1 # # - Filter: (id < 5) # # + -> Hash Join [05:33:09.153](0.000s) # ... 16 lines omitted ... [05:33:09.153](0.000s) # # Aggregate # # -> Hash Join # # Hash Cond: (t2.a = t1.a) # # - -> Nested Loop # # - -> Hash Join # # - Hash Cond: (t6.e = t5.f) # # - -> Seq Scan on t6 # # - -> Hash # # - -> Seq Scan on t5 # # - Filter: (d < 3) # # - -> Seq Scan on t2 # # + -> Seq Scan on t2 # # -> Hash # # - -> Seq Scan on t1 # # - Filter: (a < 5) # # + -> Nested Loop # # + -> Hash Join # # + Hash Cond: (t6.e = t5.f) # # + -> Seq Scan on t6 # # + -> Hash # # + -> Seq Scan on t5 # # + Filter: (d < 3) # # + -> Seq Scan on t1 # # + Filter: (a < 5) # # (14 rows) # # # # -- # # 1 of 246 tests failed. # # The differences that caused some tests to fail can be viewed in the file "/home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/regression.diffs". # # A copy of the test summary that you see above is saved in the file "/home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/regression.out". [05:33:09.153](0.000s) # ------------------------------------ # Running: pg_isready --timeout 180 --host /tmp/Ds5PGVm0S8 --port 22240 /tmp/Ds5PGVm0S8:22240 - accepting connections # Running: pg_isready --timeout 180 --host /tmp/Ds5PGVm0S8 --port 22241 /tmp/Ds5PGVm0S8:22241 - accepting connections [05:33:09.244](0.091s) ok 3 - primary alive after regression test run [05:33:09.248](0.004s) ok 4 - standby alive after regression test run 1 1 1 1 1 2 5 1 5 9 1 5 1 4001 17 1 1 -1 3 4 3 4 4 1 1 32 1 1 1 6 1 104 2 -1 1 -32768 32767 2 5 1006 1 41 1 33 -2 35 9 1 46 1 2 1 1 Waiting for replication conn standby_1's replay_lsn to pass 0/170721C0 on primary done # Running: pg_dumpall --file /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/primary.dump --no-sync --no-statistics --restrict-key test --port 22240 --no-unlogged-table-data [05:33:21.445](12.197s) ok 5 - dump primary server # Running: pg_dumpall --file /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/standby.dump --no-sync --no-statistics --restrict-key test --port 22241 [05:33:27.673](6.228s) ok 6 - dump standby server [05:33:28.767](1.094s) ok 7 - compare primary and standby dumps ### Restarting node "primary" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata --log /home/postgres/postgres/build/testrun/recovery/027_stream_regress/log/027_stream_regress_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 39605 Waiting for replication conn standby_1's replay_lsn to pass 0/17A02540 on primary done # Running: pg_dump --schema pg_catalog --file /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/catalogs_primary.dump --no-sync --restrict-key test --port 22240 --no-unlogged-table-data regression [05:33:41.087](12.321s) ok 8 - dump catalogs of primary server # Running: pg_dump --schema pg_catalog --file /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/catalogs_standby.dump --no-sync --restrict-key test --port 22241 regression [05:33:50.365](9.278s) ok 9 - dump catalogs of standby server [05:33:50.641](0.275s) ok 10 - compare primary and standby catalog dumps [05:33:51.545](0.905s) ok 11 - check contents of pg_stat_statements on regression database ### Stopping node "standby_1" using mode fast # Running: pg_ctl --pgdata /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "standby_1" ### Stopping node "primary" using mode fast # Running: pg_ctl --pgdata /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "primary" [05:33:52.155](0.610s) 1..11 [05:33:52.196](0.041s) # Looks like you failed 1 test of 11.