# Checking port 19116 # Found port 19116 Name: primary Version: 19devel Data directory: /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_primary_data/pgdata Backup directory: /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_primary_data/backup Archive directory: /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_primary_data/archives Connection string: port=19116 host=/tmp/w6vintooKl Log file: /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/log/053_max_wal_replay_size_primary.log [19:46:43.132](0.119s) # initializing database system by copying initdb template # Running: cp -RPp /home/postgres/postgres/build/tmp_install/initdb-template /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_primary_data/pgdata # Running: /home/postgres/postgres/build/src/test/regress/pg_regress --config-auth /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_primary_data/pgdata ### Starting node "primary" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_primary_data/pgdata --log /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/log/053_max_wal_replay_size_primary.log --options --cluster-name=primary start waiting for server to start.... done server started # Postmaster PID for node "primary" is 30789 # Taking pg_basebackup my_backup1 from node "primary" # Running: pg_basebackup --no-sync --pgdata /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_primary_data/backup/my_backup1 --host /tmp/w6vintooKl --port 19116 --checkpoint fast # Backup finished # Checking port 19117 # Found port 19117 Name: standby1 Version: 19devel Data directory: /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_standby1_data/pgdata Backup directory: /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_standby1_data/backup Archive directory: /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_standby1_data/archives Connection string: port=19117 host=/tmp/w6vintooKl Log file: /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/log/053_max_wal_replay_size_standby1.log # Initializing node "standby1" from backup "my_backup1" of node "primary" ### Enabling streaming replication for node "standby1" ### Starting node "standby1" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_standby1_data/pgdata --log /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/log/053_max_wal_replay_size_standby1.log --options --cluster-name=standby1 start waiting for server to start.... done server started # Postmaster PID for node "standby1" is 36902 # Taking pg_basebackup my_backup2 from node "primary" # Running: pg_basebackup --no-sync --pgdata /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_primary_data/backup/my_backup2 --host /tmp/w6vintooKl --port 19116 --checkpoint fast # Backup finished # Checking port 19118 # Found port 19118 Name: standby2 Version: 19devel Data directory: /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_standby2_data/pgdata Backup directory: /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_standby2_data/backup Archive directory: /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_standby2_data/archives Connection string: port=19118 host=/tmp/w6vintooKl Log file: /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/log/053_max_wal_replay_size_standby2.log # Initializing node "standby2" from backup "my_backup2" of node "primary" ### Enabling streaming replication for node "standby2" ### Starting node "standby2" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_standby2_data/pgdata --log /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/log/053_max_wal_replay_size_standby2.log --options --cluster-name=standby2 start waiting for server to start.... done server started # Postmaster PID for node "standby2" is 64688 # Checking port 19119 # Found port 19119 Name: standby3 Version: 19devel Data directory: /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_standby3_data/pgdata Backup directory: /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_standby3_data/backup Archive directory: /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_standby3_data/archives Connection string: port=19119 host=/tmp/w6vintooKl Log file: /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/log/053_max_wal_replay_size_standby3.log # Initializing node "standby3" from backup "my_backup2" of node "primary" ### Starting node "standby3" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_standby3_data/pgdata --log /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/log/053_max_wal_replay_size_standby3.log --options --cluster-name=standby3 start waiting for server to start.... done server started # Postmaster PID for node "standby3" is 59553 [19:46:54.452](11.321s) ok 1 - Connects to standby1 with high size threshold (1GB) [19:46:54.675](0.223s) not ok 2 - Skips standby1 due to replay size, connects to standby2 [19:46:54.676](0.001s) # Failed test 'Skips standby1 due to replay size, connects to standby2' # at /home/postgres/postgres/src/test/recovery/t/053_max_wal_replay_size.pl line 80. [19:46:54.676](0.000s) # got: '' # expected: '19118' [19:46:54.736](0.060s) ok 3 - Connects to primary (prefer-standby) due to standby1 replay size [19:46:54.841](0.106s) ok 4 - Connects to primary (any) due to standby1 replay size [19:46:54.908](0.066s) ok 5 - Connection rejected: replay size exceeds 1MB [19:46:54.960](0.052s) ok 6 - Rejects non-numeric max_wal_replay_size value [19:46:54.992](0.032s) ok 7 - Rejects negative max_wal_replay_size value [19:46:55.131](0.139s) ok 8 - Connects when replay lag equals threshold exactly (16777216 bytes) [19:46:55.206](0.075s) ok 9 - Connection rejected: replay size exceeds max_wal_replay_size (16777215 bytes) ### Restarting node "standby2" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_standby2_data/pgdata --log /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/log/053_max_wal_replay_size_standby2.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "standby2" is 75174 [19:46:56.178](0.972s) ok 10 - Connects to standby2 after restart [19:46:56.263](0.085s) ok 11 - Rejects standby with no active WAL receiver [19:46:56.390](0.127s) ok 12 - read-only: skips standby1 due to replay size, connects to standby2 [19:46:56.462](0.072s) ok 13 - read-write: max_wal_replay_size check bypassed, connects to primary [19:46:56.466](0.005s) 1..13 ### Stopping node "primary" using mode immediate # Running: pg_ctl --pgdata /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_primary_data/pgdata --mode immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "primary" ### Stopping node "standby1" using mode immediate # Running: pg_ctl --pgdata /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_standby1_data/pgdata --mode immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "standby1" ### Stopping node "standby2" using mode immediate # Running: pg_ctl --pgdata /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_standby2_data/pgdata --mode immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "standby2" ### Stopping node "standby3" using mode immediate # Running: pg_ctl --pgdata /home/postgres/postgres/build/testrun/recovery/053_max_wal_replay_size/data/t_053_max_wal_replay_size_standby3_data/pgdata --mode immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "standby3" [19:46:57.381](0.914s) # Looks like you failed 1 test of 13.