# Checking port 55251
# Found port 55251
Name: publisher
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_publisher_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_publisher_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_publisher_data/archives
Connection string: port=55251 host=/tmp/WwbFhkjdwC
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/004_sync_publisher.log
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_publisher_data/pgdata -A trust -N
The files belonging to this database system will be owned by user "nm".
This user must also own the server process.

The database cluster will be initialized with this locale configuration:
  provider:    libc
  LC_COLLATE:  en_US
  LC_CTYPE:    en_US
  LC_MESSAGES: C
  LC_MONETARY: en_US
  LC_NUMERIC:  en_US
  LC_TIME:     en_US
The default database encoding has accordingly been set to "LATIN1".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_publisher_data/pgdata ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... CUT0
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok

Sync to disk skipped.
The data directory might become corrupt if the operating system crashes.

Success. You can now start the database server using:

    pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_publisher_data/pgdata -l logfile start

# Running: /home/nm/src/pg/postgresql/src/test/subscription/../../../src/test/regress/pg_regress --config-auth /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_publisher_data/pgdata
### Starting node "publisher"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_publisher_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/004_sync_publisher.log -o --cluster-name=publisher start
waiting for server to start.... done
server started
# Postmaster PID for node "publisher" is 8258240
# Checking port 55252
# Found port 55252
Name: subscriber
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_subscriber_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_subscriber_data/archives
Connection string: port=55252 host=/tmp/WwbFhkjdwC
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/004_sync_subscriber.log
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata -A trust -N
The files belonging to this database system will be owned by user "nm".
This user must also own the server process.

The database cluster will be initialized with this locale configuration:
  provider:    libc
  LC_COLLATE:  en_US
  LC_CTYPE:    en_US
  LC_MESSAGES: C
  LC_MONETARY: en_US
  LC_NUMERIC:  en_US
  LC_TIME:     en_US
The default database encoding has accordingly been set to "LATIN1".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... CUT0
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok

Sync to disk skipped.
The data directory might become corrupt if the operating system crashes.

Success. You can now start the database server using:

    pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata -l logfile start

# Running: /home/nm/src/pg/postgresql/src/test/subscription/../../../src/test/regress/pg_regress --config-auth /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata
### Starting node "subscriber"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/004_sync_subscriber.log -o --cluster-name=subscriber start
waiting for server to start.... done
server started
# Postmaster PID for node "subscriber" is 4653776
#### Begin standard error
psql:<stdin>:1: NOTICE:  created replication slot "tap_sub" on publisher
#### End standard error
Waiting for replication conn tap_sub's replay_lsn to pass 0/14E9170 on publisher
done
ok 1 - initial data synced for first sub
#### Begin standard error
psql:<stdin>:1: NOTICE:  dropped replication slot "tap_sub" on publisher
#### End standard error
#### Begin standard error
psql:<stdin>:1: NOTICE:  created replication slot "tap_sub" on publisher
#### End standard error
ok 2 - initial data synced for second sub
#### Begin standard error
psql:<stdin>:1: NOTICE:  created replication slot "tap_sub2" on publisher
#### End standard error
#### Begin standard error
psql:<stdin>:1: NOTICE:  dropped replication slot "tap_sub" on publisher
#### End standard error
#### Begin standard error
psql:<stdin>:1: NOTICE:  dropped replication slot "tap_sub2" on publisher
#### End standard error
ok 3 - second and third sub are dropped
#### Begin standard error
psql:<stdin>:1: NOTICE:  created replication slot "tap_sub" on publisher
#### End standard error
ok 4 - initial data synced for fourth sub
Waiting for replication conn tap_sub's replay_lsn to pass 0/14EDBE0 on publisher
done
ok 5 - no data for table added after subscription initialized
ok 6 - data for table added after subscription initialized are now synced
Waiting for replication conn tap_sub's replay_lsn to pass 0/14EDEC8 on publisher
done
ok 7 - changes for table added after subscription initialized replicated
#### Begin standard error
psql:<stdin>:1: NOTICE:  dropped replication slot "tap_sub" on publisher
#### End standard error
#### Begin standard error
psql:<stdin>:1: NOTICE:  created replication slot "tap_sub" on publisher
#### End standard error
#### Begin standard error
psql:<stdin>:1: NOTICE:  dropped replication slot "pg_16396_sync_16384_7081696677353648842" on publisher
psql:<stdin>:1: NOTICE:  dropped replication slot "tap_sub" on publisher
#### End standard error
ok 8 - DROP SUBSCRIPTION during error can clean up the slots on the publisher
### Stopping node "subscriber" using mode fast
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_subscriber_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "subscriber"
### Stopping node "publisher" using mode fast
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_004_sync_publisher_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "publisher"
1..8
