# Checking port 58808 # Found port 58808 Name: primary Data directory: /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_primary_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_primary_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_primary_data/archives Connection string: port=58808 host=/tmp/Y97lw9Wiy6 Log file: /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/log/007_sync_rep_primary.log [01:00:05.208](0.027s) # initializing database system by copying initdb template # Running: cp -RPp /tmp/cirrus-ci-build/build/tmp_install/initdb-template /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_primary_data/pgdata # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_primary_data/pgdata ### Starting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_primary_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/log/007_sync_rep_primary.log -o --cluster-name=primary start pg_ctl: another server might be running; trying to start server anyway waiting for server to start.... done server started # Postmaster PID for node "primary" is 22563 # Taking pg_basebackup primary_backup from node "primary" # Running: pg_basebackup -D /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_primary_data/backup/primary_backup -h /tmp/Y97lw9Wiy6 -p 58808 --checkpoint fast --no-sync # Backup finished # Checking port 58809 # Found port 58809 Name: standby1 Data directory: /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_standby1_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_standby1_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_standby1_data/archives Connection string: port=58809 host=/tmp/Y97lw9Wiy6 Log file: /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/log/007_sync_rep_standby1.log # Initializing node "standby1" from backup "primary_backup" of node "primary" ### Enabling streaming replication for node "standby1" ### Starting node "standby1" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_standby1_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/log/007_sync_rep_standby1.log -o --cluster-name=standby1 start waiting for server to start.... done server started # Postmaster PID for node "standby1" is 22703 ### Waiting for standby "standby1" on "primary" [01:03:25.299](200.091s) # poll_query_until timed out executing this query: # SELECT count(1) = 1 FROM pg_stat_replication WHERE application_name = 'standby1' # expecting this output: # t # last actual query output: # # with stderr: # psql: error: connection to server on socket "/tmp/Y97lw9Wiy6/.s.PGSQL.58808" failed: FATAL: database "postgres" does not exist # Checking port 58810 # Found port 58810 Name: standby2 Data directory: /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_standby2_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_standby2_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_standby2_data/archives Connection string: port=58810 host=/tmp/Y97lw9Wiy6 Log file: /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/log/007_sync_rep_standby2.log # Initializing node "standby2" from backup "primary_backup" of node "primary" ### Enabling streaming replication for node "standby2" ### Starting node "standby2" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_standby2_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/log/007_sync_rep_standby2.log -o --cluster-name=standby2 start waiting for server to start.... done server started # Postmaster PID for node "standby2" is 40719 ### Waiting for standby "standby2" on "primary" [01:06:43.073](197.774s) # poll_query_until timed out executing this query: # SELECT count(1) = 1 FROM pg_stat_replication WHERE application_name = 'standby2' # expecting this output: # t # last actual query output: # # with stderr: # psql: error: connection to server on socket "/tmp/Y97lw9Wiy6/.s.PGSQL.58808" failed: FATAL: database "postgres" does not exist # Checking port 58811 # Found port 58811 Name: standby3 Data directory: /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_standby3_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_standby3_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_standby3_data/archives Connection string: port=58811 host=/tmp/Y97lw9Wiy6 Log file: /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/log/007_sync_rep_standby3.log # Initializing node "standby3" from backup "primary_backup" of node "primary" ### Enabling streaming replication for node "standby3" ### Starting node "standby3" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_standby3_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/log/007_sync_rep_standby3.log -o --cluster-name=standby3 start waiting for server to start.... done server started # Postmaster PID for node "standby3" is 44847 ### Waiting for standby "standby3" on "primary" [01:10:00.491](197.417s) # poll_query_until timed out executing this query: # SELECT count(1) = 1 FROM pg_stat_replication WHERE application_name = 'standby3' # expecting this output: # t # last actual query output: # # with stderr: # psql: error: connection to server on socket "/tmp/Y97lw9Wiy6/.s.PGSQL.58808" failed: FATAL: database "postgres" does not exist connection error: 'psql: error: connection to server on socket "/tmp/Y97lw9Wiy6/.s.PGSQL.58808" failed: FATAL: database "postgres" does not exist' while running 'psql -XAtq -d port=58808 host=/tmp/Y97lw9Wiy6 dbname='postgres' -f - -v ON_ERROR_STOP=1' at /tmp/cirrus-ci-build/src/test/perl/PostgreSQL/Test/Cluster.pm line 2043. # Postmaster PID for node "primary" is 22563 ### Stopping node "primary" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_primary_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "primary" # Postmaster PID for node "standby1" is 22703 ### Stopping node "standby1" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_standby1_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "standby1" # Postmaster PID for node "standby2" is 40719 ### Stopping node "standby2" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_standby2_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "standby2" # Postmaster PID for node "standby3" is 44847 ### Stopping node "standby3" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/recovery/007_sync_rep/data/t_007_sync_rep_standby3_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "standby3"