# Checking port 32563 # Found port 32563 Name: primary Version: 19devel Data directory: /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/backup Archive directory: /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/archives Connection string: port=32563 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/ohd5HHGo38 Log file: /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/log/027_stream_regress_primary.log [05:32:09.202](0.046s) # initializing database system by copying initdb template # Running: cp -RPp /Users/admin/pgsql/build/tmp_install/initdb-template /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata ### Starting node "primary" # Running: pg_ctl --wait --pgdata /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata --log /Users/admin/pgsql/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 20065 (standby_1,) [05:32:11.094](1.892s) ok 1 - physical slot created on primary # Taking pg_basebackup my_backup from node "primary" # Running: pg_basebackup --no-sync --pgdata /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/backup/my_backup --host /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/ohd5HHGo38 --port 32563 --checkpoint fast # Backup finished # Checking port 32564 # Found port 32564 Name: standby_1 Version: 19devel Data directory: /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/backup Archive directory: /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/archives Connection string: port=32564 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/ohd5HHGo38 Log file: /Users/admin/pgsql/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 /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/pgdata --log /Users/admin/pgsql/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 20235 # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --dlpath=/Users/admin/pgsql/build/src/test/regress --bindir= --host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/ohd5HHGo38 --port=32563 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data [05:34:54.380](163.286s) not ok 2 - regression tests pass [05:34:54.383](0.003s) # Failed test 'regression tests pass' # at /Users/admin/pgsql/src/test/recovery/t/027_stream_regress.pl line 74. [05:34:54.384](0.001s) # ---------- command failed ---------- [05:34:54.384](0.000s) # /Users/admin/pgsql/build/src/test/regress/pg_regress --dlpath=/Users/admin/pgsql/build/src/test/regress --bindir= --host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/ohd5HHGo38 --port=32563 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data [05:34:54.384](0.000s) # -------------- stdout -------------- [05:34:54.385](0.001s) # # using postmaster on /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/ohd5HHGo38, port 32563 # ok 1 - test_setup 906 ms # # parallel group (20 tests): name oid boolean txid uuid text varchar float8 pg_lsn float4 char int4 int2 int8 money regproc bit enum rangetypes numeric # ok 2 + boolean 591 ms # ok 3 + char 685 ms # ok 4 + name 569 ms # ok 5 + varchar 632 ms # ok 6 + text 620 ms # ok 7 + int2 727 ms # ok 8 + int4 686 ms # ok 9 + int8 757 ms # ok 10 + oid 576 ms # ok 11 + float4 676 ms # ok 12 + float8 642 ms # ok 13 + bit 861 ms # ok 14 + numeric 1725 ms # ok 15 + txid 583 ms # ok 16 + uuid 598 ms # ok 17 + enum 901 ms # ok 18 + money 744 ms # ok 19 + rangetypes 1605 ms # ok 20 + pg_lsn 597 ms # ok 21 + regproc 700 ms # # parallel group (20 tests): lseg line md5 point circle numerology time timetz path macaddr8 inet macaddr date timestamp interval strings polygon timestamptz box multirangetypes # ok 22 + strings 1274 ms # ok 23 + md5 262 ms # ok 24 + numerology 568 ms # ok 25 + point 267 ms # ok 26 + lseg 253 ms # ok 27 + line 254 ms [05:34:54.386](0.000s) # ... 207 lines omitted ... [05:34:54.386](0.000s) # ok 220 + partition_merge 5198 ms # ok 221 + partition_split 6721 ms # ok 222 + partition_join 8060 ms # ok 223 + partition_prune 8339 ms # ok 224 + reloptions 663 ms # ok 225 + hash_part 666 ms # ok 226 + indexing 9567 ms # ok 227 + partition_aggregate 4696 ms # ok 228 + partition_info 645 ms # ok 229 + tuplesort 4859 ms # ok 230 + explain 921 ms # ok 231 + memoize 2359 ms # ok 232 + stats 7102 ms # ok 233 + predicate 904 ms # ok 234 + numa 313 ms # ok 235 + eager_aggregate 2052 ms # ok 236 + graph_table_rls 1051 ms # ok 237 + planner_est 380 ms # # parallel group (4 tests): compression_pglz compression compression_lz4 cluster # ok 238 + compression 977 ms # ok 239 + compression_lz4 1026 ms # ok 240 + compression_pglz 298 ms # ok 241 + cluster 2356 ms # # parallel group (2 tests): oidjoins event_trigger # ok 242 + oidjoins 2159 ms # ok 243 + event_trigger 2374 ms # ok 244 - event_trigger_login 175 ms # ok 245 - fast_default 1963 ms # ok 246 - tablespace 2694 ms # 1..246 [05:34:54.386](0.000s) # -------------- stderr -------------- [05:34:54.386](0.000s) # # diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/goo.out # # --- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-05-06 05:25:20 # # +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-05-06 05:33:15 # # @@ -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:34:54.386](0.000s) # ... 16 lines omitted ... [05:34:54.386](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 "/Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/regression.diffs". # # A copy of the test summary that you see above is saved in the file "/Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/regression.out". [05:34:54.386](0.000s) # ------------------------------------ # Running: pg_isready --timeout 180 --host /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/ohd5HHGo38 --port 32563 /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/ohd5HHGo38:32563 - accepting connections # Running: pg_isready --timeout 180 --host /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/ohd5HHGo38 --port 32564 /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/ohd5HHGo38:32564 - accepting connections [05:34:54.661](0.275s) ok 3 - primary alive after regression test run [05:34:54.662](0.001s) ok 4 - standby alive after regression test run 1 1 1 1 1 2 1 1 9 1 5 5 1 1 -1 1 1 3 4 3 4001 4 4 1 -1 32 1 1 1 6 -32768 32767 104 2 1 41 2 5 1006 -2 9 1 1 1 46 33 35 1 2 1 1 5 17 Waiting for replication conn standby_1's replay_lsn to pass 0/17331CA8 on primary done # Running: pg_dumpall --file /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/primary.dump --no-sync --no-statistics --restrict-key test --port 32563 --no-unlogged-table-data [05:35:05.998](11.336s) ok 5 - dump primary server # Running: pg_dumpall --file /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/standby.dump --no-sync --no-statistics --restrict-key test --port 32564 [05:35:16.262](10.264s) ok 6 - dump standby server [05:35:16.674](0.412s) ok 7 - compare primary and standby dumps ### Restarting node "primary" # Running: pg_ctl --wait --pgdata /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata --log /Users/admin/pgsql/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 31583 Waiting for replication conn standby_1's replay_lsn to pass 0/17CED250 on primary done # Running: pg_dump --schema pg_catalog --file /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/catalogs_primary.dump --no-sync --restrict-key test --port 32563 --no-unlogged-table-data regression [05:35:24.380](7.705s) ok 8 - dump catalogs of primary server # Running: pg_dump --schema pg_catalog --file /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/catalogs_standby.dump --no-sync --restrict-key test --port 32564 regression [05:35:32.433](8.054s) ok 9 - dump catalogs of standby server [05:35:32.497](0.064s) ok 10 - compare primary and standby catalog dumps [05:35:33.297](0.800s) ok 11 - check contents of pg_stat_statements on regression database ### Stopping node "standby_1" using mode fast # Running: pg_ctl --pgdata /Users/admin/pgsql/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 /Users/admin/pgsql/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:35:33.645](0.347s) 1..11 [05:35:33.648](0.003s) # Looks like you failed 1 test of 11.