# Checking port 29021 # Found port 29021 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=29021 host=/tmp/NdaZEEzj0d Log file: /home/postgres/postgres/build/testrun/recovery/027_stream_regress/log/027_stream_regress_primary.log [07:16:30.961](0.036s) # 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 98826 (standby_1,) [07:16:31.683](0.723s) 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/NdaZEEzj0d --port 29021 --checkpoint fast # Backup finished # Checking port 29022 # Found port 29022 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=29022 host=/tmp/NdaZEEzj0d 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 69146 # Running: /home/postgres/postgres/build/src/test/regress/pg_regress --dlpath=/home/postgres/postgres/build/src/test/regress --bindir= --host=/tmp/NdaZEEzj0d --port=29021 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/home/postgres/postgres/build/testrun/recovery/027_stream_regress/data [07:20:18.371](226.688s) not ok 2 - regression tests pass [07:20:18.372](0.001s) # Failed test 'regression tests pass' # at /home/postgres/postgres/src/test/recovery/t/027_stream_regress.pl line 74. [07:20:18.373](0.001s) # ---------- command failed ---------- [07:20:18.375](0.002s) # /home/postgres/postgres/build/src/test/regress/pg_regress --dlpath=/home/postgres/postgres/build/src/test/regress --bindir= --host=/tmp/NdaZEEzj0d --port=29021 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/home/postgres/postgres/build/testrun/recovery/027_stream_regress/data [07:20:18.375](0.000s) # -------------- stdout -------------- [07:20:18.377](0.002s) # # using postmaster on /tmp/NdaZEEzj0d, port 29021 # ok 1 - test_setup 4260 ms # # parallel group (20 tests): varchar pg_lsn oid int2 txid boolean name char uuid int8 int4 money text regproc float4 enum bit float8 numeric rangetypes # ok 2 + boolean 372 ms # ok 3 + char 491 ms # ok 4 + name 474 ms # ok 5 + varchar 120 ms # ok 6 + text 1082 ms # ok 7 + int2 231 ms # ok 8 + int4 986 ms # ok 9 + int8 764 ms # ok 10 + oid 205 ms # ok 11 + float4 1285 ms # ok 12 + float8 1597 ms # ok 13 + bit 1438 ms # ok 14 + numeric 3592 ms # ok 15 + txid 217 ms # ok 16 + uuid 723 ms # ok 17 + enum 1340 ms # ok 18 + money 994 ms # ok 19 + rangetypes 5126 ms # ok 20 + pg_lsn 168 ms # ok 21 + regproc 1094 ms # # parallel group (20 tests): md5 lseg path circle line macaddr point time timetz numerology macaddr8 inet date timestamp timestamptz interval multirangetypes polygon strings box # ok 22 + strings 3000 ms # ok 23 + md5 300 ms # ok 24 + numerology 792 ms # ok 25 + point 603 ms # ok 26 + lseg 365 ms # ok 27 + line 467 ms [07:20:18.378](0.001s) # ... 206 lines omitted ... [07:20:18.379](0.001s) # ok 219 + partition_merge 10742 ms # ok 220 + partition_split 9790 ms # ok 221 + partition_join 13949 ms # ok 222 + partition_prune 9749 ms # ok 223 + reloptions 866 ms # ok 224 + hash_part 392 ms # ok 225 + indexing 18683 ms # ok 226 + partition_aggregate 6542 ms # ok 227 + partition_info 1557 ms # ok 228 + tuplesort 7590 ms # ok 229 + explain 906 ms # ok 230 + memoize 4035 ms # ok 231 + stats 11677 ms # ok 232 + predicate 1981 ms # ok 233 + numa 260 ms # ok 234 + eager_aggregate 3179 ms # ok 235 + graph_table_rls 2600 ms # ok 236 + planner_est 290 ms # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster # ok 237 + compression 2135 ms # ok 238 + compression_lz4 1696 ms # ok 239 + compression_pglz 189 ms # ok 240 + cluster 3935 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 2665 ms # ok 242 + event_trigger 2968 ms # ok 243 - event_trigger_login 291 ms # ok 244 - fast_default 2345 ms # ok 245 - tablespace 8868 ms # 1..245 [07:20:18.379](0.000s) # -------------- stderr -------------- [07:20:18.379](0.000s) # # diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out # # --- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out Tue May 5 07:11:28 2026 # # +++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out Tue May 5 07:17:17 2026 # # @@ -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 "/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". [07:20:18.380](0.000s) # ------------------------------------ # Running: pg_isready --timeout 180 --host /tmp/NdaZEEzj0d --port 29021 /tmp/NdaZEEzj0d:29021 - accepting connections # Running: pg_isready --timeout 180 --host /tmp/NdaZEEzj0d --port 29022 /tmp/NdaZEEzj0d:29022 - accepting connections [07:20:18.478](0.098s) ok 3 - primary alive after regression test run [07:20:18.478](0.000s) ok 4 - standby alive after regression test run 1 1 1 1 1 5 2 1 5 9 1 3 4 3 4 4 1 32 1 1 1 6 104 2 1 1 1 2 5 1006 4001 1 1 -1 1 1 -1 -32768 32767 -2 9 1 46 1 33 35 5 1 2 17 1 1 41 Waiting for replication conn standby_1's replay_lsn to pass 0/16C1FBC0 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 29021 --no-unlogged-table-data [07:20:35.630](17.152s) 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 29022 [07:20:42.612](6.982s) ok 6 - dump standby server [07:20:43.299](0.687s) 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 9750 Waiting for replication conn standby_1's replay_lsn to pass 0/173BAA10 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 29021 --no-unlogged-table-data regression [07:20:57.561](14.262s) 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 29022 regression [07:21:06.407](8.846s) ok 9 - dump catalogs of standby server [07:21:06.676](0.269s) ok 10 - compare primary and standby catalog dumps [07:21:07.782](1.106s) 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" [07:21:08.359](0.577s) 1..11 [07:21:08.379](0.021s) # Looks like you failed 1 test of 11.