# Checking port 12280 # Found port 12280 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=12280 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/gkyW92QEOe Log file: /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/log/027_stream_regress_primary.log [07:14:40.509](0.095s) # 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 20305 (standby_1,) [07:14:41.593](1.085s) 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/gkyW92QEOe --port 12280 --checkpoint fast # Backup finished # Checking port 12281 # Found port 12281 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=12281 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/gkyW92QEOe 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 20564 # 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/gkyW92QEOe --port=12280 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data [07:15:53.761](72.168s) not ok 2 - regression tests pass [07:15:53.763](0.002s) # Failed test 'regression tests pass' # at /Users/admin/pgsql/src/test/recovery/t/027_stream_regress.pl line 74. [07:15:53.763](0.000s) # ---------- command failed ---------- [07:15:53.764](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/gkyW92QEOe --port=12280 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data [07:15:53.764](0.000s) # -------------- stdout -------------- [07:15:53.764](0.000s) # # using postmaster on /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/gkyW92QEOe, port 12280 # ok 1 - test_setup 765 ms # # parallel group (20 tests): name int2 text char int4 varchar int8 oid boolean pg_lsn float4 txid float8 bit money regproc enum uuid numeric rangetypes # ok 2 + boolean 324 ms # ok 3 + char 282 ms # ok 4 + name 267 ms # ok 5 + varchar 289 ms # ok 6 + text 269 ms # ok 7 + int2 255 ms # ok 8 + int4 260 ms # ok 9 + int8 285 ms # ok 10 + oid 286 ms # ok 11 + float4 369 ms # ok 12 + float8 428 ms # ok 13 + bit 419 ms # ok 14 + numeric 1129 ms # ok 15 + txid 338 ms # ok 16 + uuid 656 ms # ok 17 + enum 548 ms # ok 18 + money 385 ms # ok 19 + rangetypes 1176 ms # ok 20 + pg_lsn 262 ms # ok 21 + regproc 428 ms # # parallel group (20 tests): line lseg md5 numerology circle path macaddr time macaddr8 timetz point inet date interval strings polygon box timestamp timestamptz multirangetypes # ok 22 + strings 434 ms # ok 23 + md5 175 ms # ok 24 + numerology 184 ms # ok 25 + point 235 ms # ok 26 + lseg 166 ms # ok 27 + line 138 ms [07:15:53.764](0.000s) # ... 206 lines omitted ... [07:15:53.764](0.000s) # ok 219 + partition_merge 4082 ms # ok 220 + partition_split 5349 ms # ok 221 + partition_join 5633 ms # ok 222 + partition_prune 6216 ms # ok 223 + reloptions 573 ms # ok 224 + hash_part 344 ms # ok 225 + indexing 7775 ms # ok 226 + partition_aggregate 3331 ms # ok 227 + partition_info 896 ms # ok 228 + tuplesort 4086 ms # ok 229 + explain 482 ms # ok 230 + memoize 2325 ms # ok 231 + stats 4528 ms # ok 232 + predicate 895 ms # ok 233 + numa 100 ms # ok 234 + eager_aggregate 1105 ms # ok 235 + graph_table_rls 965 ms # ok 236 + planner_est 288 ms # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster # ok 237 + compression 905 ms # ok 238 + compression_lz4 524 ms # ok 239 + compression_pglz 108 ms # ok 240 + cluster 1782 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 1727 ms # ok 242 + event_trigger 1882 ms # ok 243 - event_trigger_login 121 ms # ok 244 - fast_default 694 ms # ok 245 - tablespace 2658 ms # 1..245 [07:15:53.764](0.000s) # -------------- stderr -------------- [07:15:53.764](0.000s) # # diff -U3 /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out # # --- /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out 2026-05-05 07:10:48 # # +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-05-05 07:14:55 # # @@ -1099,8 +1099,6 @@ # # FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' # # SET name = 'one^3' # # WHERE id = 1; # # -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" # # -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). # # ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; # # -- test inserts violating CHECK constraints # # ALTER TABLE for_portion_of_test2 # # @@ -1115,12 +1113,13 @@ # # SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; # # id | valid_at | name # # ----+-------------------------+------- # # - 1 | [2000-01-01,2010-01-01) | one # # + 1 | [2000-01-01,2001-01-11) | one^3 # # + 1 | [2001-01-11,2010-01-01) | one # # 1 | [2010-01-01,2010-01-05) | one^1 # # 1 | [2010-01-05,2010-01-07) | one # # 1 | [2010-01-07,2010-01-09) | one^2 # # 1 | [2010-01-09,2020-01-01) | one # # -(5 rows) # # +(6 rows) # # # # -- DELETE works: # # DELETE FROM for_portion_of_test2 # # @@ -1222,8 +1221,6 @@ # # FOR PORTION OF valid_at ('{[2000-01-01,2001-01-11)}') # # SET name = 'one^3' # # WHERE id = 1; # # -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" # # -DETAIL: Failing row contains (1, {[2000-01-01,2001-01-11)}, one^3). # # ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; # # -- test inserts violating CHECK constraints # # ALTER TABLE for_portion_of_test2 # # @@ -1233,14 +1230,15 @@ # # SET name = 'one^3' # # WHERE id = 1; # # ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" # # -DETAIL: Failing row contains (1, {[2000-01-01,2001-01-01),[2002-02-02,2010-01-07),[2010-01-09,202..., one). # # +DETAIL: Failing row contains (1, {[2002-02-02,2010-01-07),[2010-01-09,2020-01-01)}, one). # # ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; # # SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; # # id | valid_at | name # # ----+---------------------------------------------------+------- # # - 1 | {[2000-01-01,2010-01-07),[2010-01-09,2020-01-01)} | one # # + 1 | {[2000-01-01,2001-01-11)} | one^3 # # + 1 | {[2001-01-11,2010-01-07),[2010-01-09,2020-01-01)} | one # # 1 | {[2010-01-07,2010-01-09)} | one^2 # # -(2 rows) # # +(3 rows) # # # # -- DELETE works: # # DELETE FROM for_portion_of_test2 # # 1 of 245 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". [07:15:53.764](0.000s) # ------------------------------------ # Running: pg_isready --timeout 180 --host /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/gkyW92QEOe --port 12280 /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/gkyW92QEOe:12280 - accepting connections # Running: pg_isready --timeout 180 --host /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/gkyW92QEOe --port 12281 /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/gkyW92QEOe:12281 - accepting connections [07:15:53.887](0.122s) ok 3 - primary alive after regression test run [07:15:53.887](0.000s) ok 4 - standby alive after regression test run 1 1 1 1 1 2 1 5 9 5 3 4 4001 3 4 4 1 32 1 1 1 41 6 104 2 1 2 5 1006 1 2 1 1 -1 1 1 1 1 -1 -32768 32767 5 17 1 1 -2 9 1 46 1 1 33 35 Waiting for replication conn standby_1's replay_lsn to pass 0/16208758 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 12280 --no-unlogged-table-data [07:15:59.731](5.845s) 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 12281 [07:16:04.358](4.627s) ok 6 - dump standby server [07:16:04.638](0.279s) 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 31086 Waiting for replication conn standby_1's replay_lsn to pass 0/16AD7A30 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 12280 --no-unlogged-table-data regression [07:16:08.591](3.953s) 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 12281 regression [07:16:11.799](3.209s) ok 9 - dump catalogs of standby server [07:16:11.841](0.042s) ok 10 - compare primary and standby catalog dumps [07:16:12.093](0.252s) 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" [07:16:12.341](0.248s) 1..11 [07:16:12.345](0.003s) # Looks like you failed 1 test of 11.