# Checking port 54812 # Found port 54812 Name: primary_local Data directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_primary_local_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_primary_local_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_primary_local_data/archives Connection string: port=54812 host=/tmp/piCM8M0XjS Log file: /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/log/001_basic_primary_local.log [02:11:29.649](0.068s) # 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/pg_rewind/001_basic/data/t_001_basic_primary_local_data/pgdata # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_primary_local_data/pgdata --create-role rewind_user ### Starting node "primary_local" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_primary_local_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/log/001_basic_primary_local.log -o --cluster-name=primary_local start waiting for server to start.... done server started # Postmaster PID for node "primary_local" is 64585 # Running: psql -q --no-psqlrc -d port=54812 host=/tmp/piCM8M0XjS dbname='postgres' -c CREATE TABLESPACE space_test LOCATION '' # Running: psql -q --no-psqlrc -d port=54812 host=/tmp/piCM8M0XjS dbname='postgres' -c CREATE TABLE space_tbl (d text) TABLESPACE space_test # Running: psql -q --no-psqlrc -d port=54812 host=/tmp/piCM8M0XjS dbname='postgres' -c INSERT INTO space_tbl VALUES ('in primary, before promotion') # Running: psql -q --no-psqlrc -d port=54812 host=/tmp/piCM8M0XjS dbname='postgres' -c CREATE TABLE tbl1 (d text) # Running: psql -q --no-psqlrc -d port=54812 host=/tmp/piCM8M0XjS dbname='postgres' -c INSERT INTO tbl1 VALUES ('in primary') # Running: psql -q --no-psqlrc -d port=54812 host=/tmp/piCM8M0XjS dbname='postgres' -c CREATE TABLE trunc_tbl (d text) # Running: psql -q --no-psqlrc -d port=54812 host=/tmp/piCM8M0XjS dbname='postgres' -c INSERT INTO trunc_tbl VALUES ('in primary') # Running: psql -q --no-psqlrc -d port=54812 host=/tmp/piCM8M0XjS dbname='postgres' -c CREATE TABLE tail_tbl (id integer, d text) # Running: psql -q --no-psqlrc -d port=54812 host=/tmp/piCM8M0XjS dbname='postgres' -c INSERT INTO tail_tbl VALUES (0, 'in primary') # Running: psql -q --no-psqlrc -d port=54812 host=/tmp/piCM8M0XjS dbname='postgres' -c CREATE TABLE drop_tbl (d text) # Running: psql -q --no-psqlrc -d port=54812 host=/tmp/piCM8M0XjS dbname='postgres' -c INSERT INTO drop_tbl VALUES ('in primary') # Running: psql -q --no-psqlrc -d port=54812 host=/tmp/piCM8M0XjS dbname='postgres' -c CHECKPOINT # Checking port 54813 # Found port 54813 Name: standby_local Data directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_standby_local_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_standby_local_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_standby_local_data/archives Connection string: port=54813 host=/tmp/piCM8M0XjS Log file: /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/log/001_basic_standby_local.log # Taking pg_basebackup my_backup from node "primary_local" # Running: pg_basebackup -D /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_primary_local_data/backup/my_backup -h /tmp/piCM8M0XjS -p 54812 --checkpoint fast --no-sync # Backup finished # Initializing node "standby_local" from backup "my_backup" of node "primary_local" ### Starting node "standby_local" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_standby_local_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/log/001_basic_standby_local.log -o --cluster-name=standby_local start waiting for server to start.... done server started # Postmaster PID for node "standby_local" is 64722 # Running: psql -q --no-psqlrc -d port=54812 host=/tmp/piCM8M0XjS dbname='postgres' -c INSERT INTO tbl1 values ('in primary, before promotion') # Running: psql -q --no-psqlrc -d port=54812 host=/tmp/piCM8M0XjS dbname='postgres' -c INSERT INTO trunc_tbl values ('in primary, before promotion') # Running: psql -q --no-psqlrc -d port=54812 host=/tmp/piCM8M0XjS dbname='postgres' -c INSERT INTO tail_tbl SELECT g, 'in primary, before promotion: ' || g FROM generate_series(1, 10000) g # Running: psql -q --no-psqlrc -d port=54812 host=/tmp/piCM8M0XjS dbname='postgres' -c CHECKPOINT Waiting for replication conn standby_local's write_lsn to pass 0/30EB438 on primary_local done ### Promoting node "standby_local" # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_standby_local_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/log/001_basic_standby_local.log promote waiting for server to promote.... stopped waiting pg_ctl: server did not promote in time [02:11:30.903](1.254s) Bail out! command "pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_standby_local_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/log/001_basic_standby_local.log promote" exited with value 1 # Postmaster PID for node "primary_local" is 64585 ### Stopping node "primary_local" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_primary_local_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "primary_local" # No postmaster PID for node "standby_local"