# Checking port 57417 # Found port 57417 Name: primary Data directory: C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/pgdata Backup directory: C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/backup Archive directory: C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/archives Connection string: port=57417 host=127.0.0.1 Log file: C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/log/021_row_visibility_primary.log # Running: initdb -D C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/pgdata -A trust -N The files belonging to this database system will be owned by user "IEUser". This user must also own the server process. The database cluster will be initialized with locale "English_United States.1252". The default database encoding has accordingly been set to "WIN1252". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/pgdata ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... windows selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting default time zone ... US/Pacific creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. Success. You can now start the database server using: pg_ctl -D C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/pgdata -l logfile start # Running: C:/Users/IEUser/git/postgres/Release/pg_regress/pg_regress --config-auth C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/pgdata ### Starting node "primary" # Running: pg_ctl -D C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/pgdata -l C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/log/021_row_visibility_primary.log -o --cluster-name=primary start waiting for server to start.... done server started # Postmaster PID for node "primary" is 3428 # Taking pg_basebackup my_backup from node "primary" # Running: pg_basebackup -D C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/backup/my_backup -h 127.0.0.1 -p 57417 --checkpoint fast --no-sync # Backup finished # Checking port 57418 # Found port 57418 Name: standby Data directory: C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_standby_data/pgdata Backup directory: C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_standby_data/backup Archive directory: C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_standby_data/archives Connection string: port=57418 host=127.0.0.1 Log file: C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/log/021_row_visibility_standby.log # Initializing node "standby" from backup "my_backup" of node "primary" ### Enabling streaming replication for node "standby" ### Starting node "standby" # Running: pg_ctl -D C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_standby_data/pgdata -l C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/log/021_row_visibility_standby.log -o --cluster-name=standby start waiting for server to start.... done server started # Postmaster PID for node "standby" is 3144 ok 1 - data not visible Waiting for replication conn standby's replay_lsn to pass '0/3002640' on primary done ok 2 - insert visible ok 3 - UPDATE 541 Waiting for replication conn standby's replay_lsn to pass '0/30026B8' on primary done ok 4 - uncommitted update invisible ok 5 - COMMIT Waiting for replication conn standby's replay_lsn to pass '0/30026E0' on primary done ok 6 - committed update visible ok 7 - prepared will_commit ok 8 - prepared will_abort Waiting for replication conn standby's replay_lsn to pass '0/30029E0' on primary done ok 9 - uncommitted prepared invisible Waiting for replication conn standby's replay_lsn to pass '0/3002A40' on primary done ok 10 - finished prepared visible Terminating on signal SIGBREAK(21) Terminating on signal SIGBREAK(21) Terminating on signal SIGBREAK(21) Terminating on signal SIGBREAK(21) Terminating on signal SIGBREAK(21) Terminating on signal SIGBREAK(21) Terminating on signal SIGBREAK(21)