test.log

application/octet-stream

Filename: test.log

Type: application/octet-stream

Part: 0

Message: Re: BUG #18897: Logical replication conflict after using pg_createsubscriber under heavy load

[1;36m*** STARTING TEST #1[0m
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory /home/ubuntu/Project/inst/pg_17_st_vig/primary ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default "max_connections" ... 100
selecting default "shared_buffers" ... 128MB
selecting default time zone ... Asia/Kolkata
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502665005639060419 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502665005639060419 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/752D588) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502665098857217831 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 903000
DEST COUNT = 903000
*** TEST PASSED

[1;36m*** STARTING TEST #2[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502665222397644017 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502665222397644017 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is SPLIT_R
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6B4B4C0) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502665313737150420 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 928000
DEST COUNT = 928000
*** TEST PASSED

[1;36m*** STARTING TEST #3[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502665462076874090 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502665462076874090 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/73B1710) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502665556136476872 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 947000
DEST COUNT = 947000
*** TEST PASSED

[1;36m*** STARTING TEST #4[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502665690809634326 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502665690809634326 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7594610) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502665784562290990 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 934000
DEST COUNT = 934000
*** TEST PASSED

[1;36m*** STARTING TEST #5[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502665915322207883 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502665915322207883 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/79DCE40) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502666012120555964 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 928000
DEST COUNT = 928000
*** TEST PASSED

[1;36m*** STARTING TEST #6[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502666134712151764 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502666134712151764 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7434978) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502666226159149559 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 918000
DEST COUNT = 918000
*** TEST PASSED

[1;36m*** STARTING TEST #7[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502666356332973830 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502666356332973830 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7F35C20) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502666454081745532 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 946000
DEST COUNT = 946000
*** TEST PASSED

[1;36m*** STARTING TEST #8[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502666572692389775 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502666572692389775 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6BFCAA8) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502666662021698176 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 917000
DEST COUNT = 917000
*** TEST PASSED

[1;36m*** STARTING TEST #9[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502666799765745609 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502666799765745609 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/75180A8) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502666893175927513 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 932000
DEST COUNT = 932000
*** TEST PASSED

[1;36m*** STARTING TEST #10[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502667025083265075 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502667025083265075 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7A10188) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502667119863911215 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 903000
DEST COUNT = 903000
*** TEST PASSED

[1;36m*** STARTING TEST #11[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502667239585308698 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502667239585308698 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6C2B010) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502667327706903298 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 887000
DEST COUNT = 887000
*** TEST PASSED

[1;36m*** STARTING TEST #12[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502667460169596885 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502667460169596885 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7AF91C0) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502667559517070149 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 940000
DEST COUNT = 940000
*** TEST PASSED

[1;36m*** STARTING TEST #13[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502667687025623126 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502667687025623126 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/72A3198) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502667779694154586 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 940000
DEST COUNT = 940000
*** TEST PASSED

[1;36m*** STARTING TEST #14[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502667919616254192 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502667919616254192 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT+INIT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6671200) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502668009801839585 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 936000
DEST COUNT = 936000
*** TEST PASSED

[1;36m*** STARTING TEST #15[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502668161787396495 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502668161787396495 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/762DAD0) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502668254571746428 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 924000
DEST COUNT = 924000
*** TEST PASSED

[1;36m*** STARTING TEST #16[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502668379103183313 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502668379103183313 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7DFE138) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502668474622141736 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 948000
DEST COUNT = 948000
*** TEST PASSED

[1;36m*** STARTING TEST #17[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502668598497817199 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502668598497817199 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6E5F140) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502668692333819203 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 925000
DEST COUNT = 925000
*** TEST PASSED

[1;36m*** STARTING TEST #18[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502668831438189258 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502668831438189258 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6F07DD8) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502668921493611993 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 914000
DEST COUNT = 914000
*** TEST PASSED

[1;36m*** STARTING TEST #19[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502669055442244336 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502669055442244336 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7652158) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502669148697146963 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 937000
DEST COUNT = 937000
*** TEST PASSED

[1;36m*** STARTING TEST #20[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502669278782260076 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502669278782260076 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7673840) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502669370318009978 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 912000
DEST COUNT = 912000
*** TEST PASSED

[1;36m*** STARTING TEST #21[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502669491612636020 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502669491612636020 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/743ABA0) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502669587017807505 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 946000
DEST COUNT = 946000
*** TEST PASSED

[1;36m*** STARTING TEST #22[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502669719281136662 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502669719281136662 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/731FE08) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502669814825948891 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 937000
DEST COUNT = 937000
*** TEST PASSED

[1;36m*** STARTING TEST #23[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502669950382814364 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502669950382814364 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6DF4000) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502670038747609015 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 910000
DEST COUNT = 910000
*** TEST PASSED

[1;36m*** STARTING TEST #24[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502670176592528573 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502670176592528573 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6F1C028) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502670266764527559 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 896000
DEST COUNT = 896000
*** TEST PASSED

[1;36m*** STARTING TEST #25[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502670399418496155 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502670399418496155 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6F36CE0) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502670493764278136 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 922000
DEST COUNT = 922000
*** TEST PASSED

[1;36m*** STARTING TEST #26[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502670633913398507 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502670633913398507 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/71DDF18) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502670727702001671 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 945000
DEST COUNT = 945000
*** TEST PASSED

[1;36m*** STARTING TEST #27[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502670869630174617 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502670869630174617 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6FF4B28) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502670961599043744 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 936000
DEST COUNT = 936000
*** TEST PASSED

[1;36m*** STARTING TEST #28[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502671106669139504 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502671106669139504 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6DF31F0) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502671199324612953 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 928000
DEST COUNT = 928000
*** TEST PASSED

[1;36m*** STARTING TEST #29[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502671338321659546 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502671338321659546 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7106728) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502671431579773336 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 933000
DEST COUNT = 933000
*** TEST PASSED

[1;36m*** STARTING TEST #30[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502671571908241175 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502671571908241175 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6F87900) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502671664448264817 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 926000
DEST COUNT = 926000
*** TEST PASSED

[1;36m*** STARTING TEST #31[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502671803556693880 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502671803556693880 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/80FC780) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502671898895796932 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 941000
DEST COUNT = 941000
*** TEST PASSED

[1;36m*** STARTING TEST #32[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502672012773914597 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502672012773914597 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6CD3878) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502672104271956709 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 925000
DEST COUNT = 925000
*** TEST PASSED

[1;36m*** STARTING TEST #33[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502672243123562560 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502672243123562560 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/79FEF48) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502672339180342129 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 917000
DEST COUNT = 917000
*** TEST PASSED

[1;36m*** STARTING TEST #34[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502672461232523359 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502672461232523359 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6ECA420) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502672550850329524 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 912000
DEST COUNT = 912000
*** TEST PASSED

[1;36m*** STARTING TEST #35[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502672683568687230 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502672683568687230 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/8511C98) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502672782803078188 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 953000
DEST COUNT = 953000
*** TEST PASSED

[1;36m*** STARTING TEST #36[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502672890883238162 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502672890883238162 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/72648A0) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502672981724756986 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 922000
DEST COUNT = 922000
*** TEST PASSED

[1;36m*** STARTING TEST #37[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502673116313229659 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502673116313229659 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/734AD08) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502673210640575587 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 935000
DEST COUNT = 935000
*** TEST PASSED

[1;36m*** STARTING TEST #38[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502673342723787216 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502673342723787216 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7C9F4C0) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502673436995054825 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 918000
DEST COUNT = 918000
*** TEST PASSED

[1;36m*** STARTING TEST #39[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502673553110448620 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502673553110448620 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is SPLIT_R
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7562060) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502673643702508796 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 913000
DEST COUNT = 913000
*** TEST PASSED

[1;36m*** STARTING TEST #40[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502673769500121603 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502673769500121603 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7B3AFF0) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502673864032230704 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 939000
DEST COUNT = 939000
*** TEST PASSED

[1;36m*** STARTING TEST #41[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502673987010849402 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502673987010849402 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7584220) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502674081164995984 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 900000
DEST COUNT = 900000
*** TEST PASSED

[1;36m*** STARTING TEST #42[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502674206030596700 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502674206030596700 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/79CCDC0) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502674300122570163 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 920000
DEST COUNT = 920000
*** TEST PASSED

[1;36m*** STARTING TEST #43[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502674421125421700 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502674421125421700 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/733F998) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502674516020854196 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 936000
DEST COUNT = 936000
*** TEST PASSED

[1;36m*** STARTING TEST #44[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502674651233581828 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502674651233581828 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/753BBD0) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502674742984363469 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 907000
DEST COUNT = 907000
*** TEST PASSED

[1;36m*** STARTING TEST #45[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502674868264033024 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502674868264033024 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_UPPER
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7275288) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502674962949762595 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 950000
DEST COUNT = 950000
*** TEST PASSED

[1;36m*** STARTING TEST #46[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502675100186110907 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502675100186110907 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7FA39D0) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502675196986367726 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 948000
DEST COUNT = 948000
*** TEST PASSED

[1;36m*** STARTING TEST #47[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502675315349699662 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502675315349699662 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is COMMIT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/87E9B30) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502675415471558537 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 950000
DEST COUNT = 950000
*** TEST PASSED

[1;36m*** STARTING TEST #48[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502675519492500687 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502675519492500687 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7546140) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502675611008860153 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 916000
DEST COUNT = 916000
*** TEST PASSED

[1;36m*** STARTING TEST #49[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502675737357237486 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502675737357237486 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT+INIT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7509658) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502675832746897339 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 925000
DEST COUNT = 925000
*** TEST PASSED

[1;36m*** STARTING TEST #50[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502675962346839355 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502675962346839355 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7E30480) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502676059452579995 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 934000
DEST COUNT = 934000
*** TEST PASSED

[1;36m*** STARTING TEST #51[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502676176804466071 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502676176804466071 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/710EB78) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502676267070378157 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 899000
DEST COUNT = 899000
*** TEST PASSED

[1;36m*** STARTING TEST #52[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502676395464588668 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502676395464588668 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is COMMIT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/77B38C0) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502676490420736109 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 892000
DEST COUNT = 892000
*** TEST PASSED

[1;36m*** STARTING TEST #53[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502676605068860714 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502676605068860714 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6D791D8) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502676696463204348 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 887000
DEST COUNT = 887000
*** TEST PASSED

[1;36m*** STARTING TEST #54[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502676830626356452 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502676830626356452 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6C06D48) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502676921073909688 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 900000
DEST COUNT = 900000
*** TEST PASSED

[1;36m*** STARTING TEST #55[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502677059445742812 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502677059445742812 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/67A77B8) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502677150663884769 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 916000
DEST COUNT = 916000
*** TEST PASSED

[1;36m*** STARTING TEST #56[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502677299420970275 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502677299420970275 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/74ED268) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502677393236799530 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 925000
DEST COUNT = 925000
*** TEST PASSED

[1;36m*** STARTING TEST #57[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502677524596931955 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502677524596931955 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/731CF38) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502677619849601184 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 908000
DEST COUNT = 908000
*** TEST PASSED

[1;36m*** STARTING TEST #58[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502677745785646453 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502677745785646453 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/719F6B8) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502677842346844274 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 947000
DEST COUNT = 947000
*** TEST PASSED

[1;36m*** STARTING TEST #59[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502677984084348460 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502677984084348460 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/8132038) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502678081916912000 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 940000
DEST COUNT = 940000
*** TEST PASSED

[1;36m*** STARTING TEST #60[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502678195133005460 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502678195133005460 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7583B48) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502678287532589475 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 899000
DEST COUNT = 899000
*** TEST PASSED

[1;36m*** STARTING TEST #61[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502678412147080815 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502678412147080815 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7585BE8) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502678507426165126 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 938000
DEST COUNT = 938000
*** TEST PASSED

[1;36m*** STARTING TEST #62[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502678639531826928 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502678639531826928 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/73F4490) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502678734283612662 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 939000
DEST COUNT = 939000
*** TEST PASSED

[1;36m*** STARTING TEST #63[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502678871852486532 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502678871852486532 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/76E4968) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502678964877640381 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 928000
DEST COUNT = 928000
*** TEST PASSED

[1;36m*** STARTING TEST #64[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502679096166649823 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502679096166649823 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is SPLIT_R
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6E92990) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502679186876043983 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 902000
DEST COUNT = 902000
*** TEST PASSED

[1;36m*** STARTING TEST #65[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502679319445221333 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502679319445221333 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7124370) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502679411981673176 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 908000
DEST COUNT = 908000
*** TEST PASSED

[1;36m*** STARTING TEST #66[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502679541170175964 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502679541170175964 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7A97898) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502679635995693811 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 939000
DEST COUNT = 939000
*** TEST PASSED

[1;36m*** STARTING TEST #67[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502679763601309785 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502679763601309785 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7E730A8) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502679860076893141 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 937000
DEST COUNT = 937000
*** TEST PASSED

[1;36m*** STARTING TEST #68[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502679978845049022 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502679978845049022 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7A70268) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502680071069524938 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 915000
DEST COUNT = 915000
*** TEST PASSED

[1;36m*** STARTING TEST #69[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502680187514446028 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502680187514446028 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/75650C8) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502680283527582699 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 930000
DEST COUNT = 930000
*** TEST PASSED

[1;36m*** STARTING TEST #70[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502680413583323436 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502680413583323436 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/696E040) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502680503813809221 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 934000
DEST COUNT = 934000
*** TEST PASSED

[1;36m*** STARTING TEST #71[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502680657251971524 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502680657251971524 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/74DEAC0) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502680752719394073 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 943000
DEST COUNT = 943000
*** TEST PASSED

[1;36m*** STARTING TEST #72[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502680885010530906 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502680885010530906 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7249D38) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502680979187397970 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 923000
DEST COUNT = 923000
*** TEST PASSED

[1;36m*** STARTING TEST #73[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502681109019812509 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502681109019812509 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7841850) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502681202194195988 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 933000
DEST COUNT = 933000
*** TEST PASSED

[1;36m*** STARTING TEST #74[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502681327482352390 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502681327482352390 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/6A8E850) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502681420648093276 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 934000
DEST COUNT = 934000
*** TEST PASSED

[1;36m*** STARTING TEST #75[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502681570012042136 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502681570012042136 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/788F080) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502681665621071574 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 932000
DEST COUNT = 932000
*** TEST PASSED

[1;36m*** STARTING TEST #76[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502681787288642545 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502681787288642545 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/7252898) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502681880499345093 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 944000
DEST COUNT = 944000
*** TEST PASSED

[1;36m*** STARTING TEST #77[0m
waiting for server to shut down.... done
server stopped
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "ubuntu".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

Success. You can now start the database server using:

pg_ctl -D /home/ubuntu/Project/inst/pg_17_st_vig/primary -l logfile start

waiting for server to start.... done
server started
waiting for checkpoint
22368/22368 kB (100%), 0/1 tablespace
22368/22368 kB (100%), 1/1 tablespace
waiting for server to start.... done
server started
CREATE DATABASE
CREATE TABLE
CREATE EXTENSION
*** STARTING 40 LOOPS INSERTING 1000 RECORDS PER ITERATION ...
*** Stopping replica, then running pg_createsubscriber...
waiting for server to shut down.... done
server stopped
pg_createsubscriber: validating publisher connection string
pg_createsubscriber: validating subscriber connection string
pg_createsubscriber: checking if directory "/home/ubuntu/Project/inst/pg_17_st_vig/replica" is a cluster data directory
pg_createsubscriber: getting system identifier from publisher
pg_createsubscriber: system identifier is 7502682021374182554 on publisher
pg_createsubscriber: getting system identifier from subscriber
pg_createsubscriber: system identifier is 7502682021374182554 on subscriber
pg_createsubscriber: starting the standby server with command-line options
pg_createsubscriber: server was started
pg_createsubscriber: checking settings on subscriber
pg_createsubscriber: checking settings on publisher
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: creating publication "pub" in database "test_db"
pg_createsubscriber: creating the replication slot "sub" in database "test_db"
pg_createsubscriber: create replication slot "sub" on publisher
pg_createsubscriber: consistent point lsn record type is INSERT_LEAF
pg_createsubscriber: starting the subscriber
pg_createsubscriber: server was started
pg_createsubscriber: waiting for the target server to reach the consistent state
pg_createsubscriber: target server reached the consistent state
pg_createsubscriber: hint: If pg_createsubscriber fails after this point, you must recreate the physical replica before continuing.
pg_createsubscriber: dropping publication "pub" in database "test_db"
pg_createsubscriber: creating subscription "sub" in database "test_db"
pg_createsubscriber: setting the replication progress (node name "pg_24576", LSN 0/77AA020) in database "test_db"
pg_createsubscriber: enabling subscription "sub" in database "test_db"
pg_createsubscriber: stopping the subscriber
pg_createsubscriber: server was stopped
pg_createsubscriber: modifying system identifier of subscriber
pg_createsubscriber: system identifier is 7502682114908137372 on subscriber
pg_createsubscriber: running pg_resetwal on the subscriber
pg_createsubscriber: subscriber successfully changed the system identifier
pg_createsubscriber: Done!
waiting for server to start.... done
server started
*** Successfully started logical replica on port 5341.
*** ALL INSERT LOOPS FINISHED
SOURCE COUNT = 931000
DEST COUNT = 931000
*** TEST PASSED