# Checking port 58796
# Found port 58796
Name: publisher
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_publisher_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_publisher_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_publisher_data/archives
Connection string: port=58796 host=/tmp/z9rD2IsQpN
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/001_rep_changes_publisher.log
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_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_001_rep_changes_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_001_rep_changes_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_001_rep_changes_publisher_data/pgdata
### Starting node "publisher"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_publisher_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/001_rep_changes_publisher.log -o --cluster-name=publisher start
waiting for server to start.... done
server started
# Postmaster PID for node "publisher" is 65405352
# Checking port 58797
# Found port 58797
Name: subscriber
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_subscriber_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_subscriber_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_subscriber_data/archives
Connection string: port=58797 host=/tmp/z9rD2IsQpN
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/001_rep_changes_subscriber.log
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_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_001_rep_changes_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_001_rep_changes_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_001_rep_changes_subscriber_data/pgdata
### Starting node "subscriber"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_subscriber_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/001_rep_changes_subscriber.log -o --cluster-name=subscriber start
waiting for server to start.... done
server started
# Postmaster PID for node "subscriber" is 64160042
#### 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/1530D48 on publisher
done
ok 1 - check non-replicated table is empty on subscriber
ok 2 - check initial data was copied to subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/1547220 on publisher
done
ok 3 - check replicated inserts on subscriber
ok 4 - check replicated changes on subscriber
ok 5 - check replicated changes with different column order
ok 6 - check replicated changes with REPLICA IDENTITY NOTHING
ok 7 - check replicated changes with primary key index with included columns
ok 8 - value replicated to subscriber without replica identity index
ok 9 - check rows on subscriber before table drop from publication
Waiting for replication conn tap_sub's replay_lsn to pass 0/1547780 on publisher
done
ok 10 - check rows on subscriber after table drop from publication
#### Begin standard error
psql:<stdin>:1: NOTICE:  created replication slot "tap_sub_temp1" on publisher
#### End standard error
Waiting for replication conn tap_sub_temp1's replay_lsn to pass 0/154F490 on publisher
done
ok 11 - check initial rows on subscriber with multiple publications
Waiting for replication conn tap_sub_temp1's replay_lsn to pass 0/154F570 on publisher
done
ok 12 - check rows on subscriber with multiple publications
#### Begin standard error
psql:<stdin>:1: NOTICE:  dropped replication slot "tap_sub_temp1" on publisher
#### End standard error
Waiting for replication conn tap_sub's replay_lsn to pass 0/1551D20 on publisher
done
ok 13 - update works with REPLICA IDENTITY FULL and duplicate tuples
ok 14 - update works with REPLICA IDENTITY FULL and text datums
ok 15 - update works with different column order and subscriber local values
ok 16 - update works with REPLICA IDENTITY FULL and a primary key
### Reloading node "subscriber"
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_subscriber_data/pgdata reload
server signaled
Waiting for replication conn tap_sub's replay_lsn to pass 0/1551E28 on publisher
done
ok 17 - update target row is missing
ok 18 - delete target row is missing
### Reloading node "subscriber"
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_subscriber_data/pgdata reload
server signaled
Waiting for replication conn tap_sub's replay_lsn to pass 0/1553760 on publisher
done
ok 19 - update transmits large column value
Waiting for replication conn tap_sub's replay_lsn to pass 0/1553828 on publisher
done
ok 20 - update with non-transmitted large column value
Waiting for replication conn tap_sub's replay_lsn to pass 0/1553D38 on publisher
done
ok 21 - update works with dropped publisher column
Waiting for replication conn tap_sub's replay_lsn to pass 0/1553DB8 on publisher
done
ok 22 - update works with dropped subscriber column
### Stopping node "publisher" using mode fast
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_publisher_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "publisher"
### Starting node "publisher"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_publisher_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/001_rep_changes_publisher.log -o --cluster-name=publisher start
waiting for server to start.... done
server started
# Postmaster PID for node "publisher" is 44105984
Waiting for replication conn tap_sub's replay_lsn to pass 0/155C000 on publisher
done
ok 23 - check replicated inserts after subscription publication change
ok 24 - check changes skipped after subscription publication change
Waiting for replication conn tap_sub's replay_lsn to pass 0/1566D68 on publisher
done
### Reloading node "publisher"
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_publisher_data/pgdata reload
server signaled
Waiting for replication conn tap_sub's replay_lsn to pass 0/1566F80 on publisher
done
ok 25 - empty transaction is skipped
ok 26 - check non-replicated table is empty on subscriber
### Reloading node "publisher"
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_publisher_data/pgdata reload
server signaled
ok 27 - check replicated deletes after alter publication
ok 28 - check replicated insert after alter publication
#### Begin standard error
psql:<stdin>:1: NOTICE:  dropped replication slot "tap_sub" on publisher
#### End standard error
ok 29 - check subscription was dropped on subscriber
ok 30 - check replication slot was dropped on publisher
ok 31 - check subscription relation status was dropped on subscriber
ok 32 - check replication slot was dropped on publisher
ok 33 - check replication origin was dropped on subscriber
### Stopping node "subscriber" using mode fast
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_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_001_rep_changes_publisher_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "publisher"
### Starting node "publisher"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_publisher_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/001_rep_changes_publisher.log -o --cluster-name=publisher start
waiting for server to start.... done
server started
# Postmaster PID for node "publisher" is 55378340
ok 34 - CREATE PUBLICATION while wal_level=minimal
1..34
### Stopping node "publisher" using mode immediate
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_001_rep_changes_publisher_data/pgdata -m immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "publisher"
