# Checking port 55651
# Found port 55651
Name: publisher
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_publisher_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_publisher_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_publisher_data/archives
Connection string: port=55651 host=/tmp/02af2NBR7J
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/013_partition_publisher.log
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_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_013_partition_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_013_partition_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_013_partition_publisher_data/pgdata
### Starting node "publisher"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_publisher_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/013_partition_publisher.log -o --cluster-name=publisher start
waiting for server to start.... done
server started
# Postmaster PID for node "publisher" is 64160076
# Checking port 55652
# Found port 55652
Name: subscriber1
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_subscriber1_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_subscriber1_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_subscriber1_data/archives
Connection string: port=55652 host=/tmp/02af2NBR7J
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/013_partition_subscriber1.log
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_subscriber1_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_013_partition_subscriber1_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_013_partition_subscriber1_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_013_partition_subscriber1_data/pgdata
### Starting node "subscriber1"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_subscriber1_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/013_partition_subscriber1.log -o --cluster-name=subscriber1 start
waiting for server to start.... done
server started
# Postmaster PID for node "subscriber1" is 44106046
# Checking port 55653
# Found port 55653
Name: subscriber2
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_subscriber2_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_subscriber2_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_subscriber2_data/archives
Connection string: port=55653 host=/tmp/02af2NBR7J
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/013_partition_subscriber2.log
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_subscriber2_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_013_partition_subscriber2_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_013_partition_subscriber2_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_013_partition_subscriber2_data/pgdata
### Starting node "subscriber2"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_subscriber2_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/013_partition_subscriber2.log -o --cluster-name=subscriber2 start
waiting for server to start.... done
server started
# Postmaster PID for node "subscriber2" is 33161490
#### Begin standard error
psql:<stdin>:1: NOTICE:  created replication slot "sub1" on publisher
#### End standard error
#### Begin standard error
psql:<stdin>:1: NOTICE:  created replication slot "sub2" on publisher
#### End standard error
Waiting for replication conn sub1's replay_lsn to pass 0/150CD38 on publisher
done
Waiting for replication conn sub2's replay_lsn to pass 0/150CD38 on publisher
done
ok 1 - inserts into tab1 and its partitions replicated
ok 2 - inserts into tab1_2 replicated into tab1_2_1 correctly
ok 3 - inserts into tab1_2 replicated into tab1_2_2 correctly
ok 4 - inserts into tab1_1 replicated
ok 5 - inserts into tab1_2 replicated
ok 6 - check replica insert after trigger applied on subscriber
ok 7 - inserts into tab1_def replicated
Waiting for replication conn sub1's replay_lsn to pass 0/150D038 on publisher
done
Waiting for replication conn sub2's replay_lsn to pass 0/150D038 on publisher
done
ok 8 - update of tab1_1, tab1_2 replicated
ok 9 - updates of tab1_2 replicated into tab1_2_1 correctly
ok 10 - updates of tab1_2 replicated into tab1_2_2 correctly
ok 11 - check replica update after trigger applied on subscriber
ok 12 - update of tab1_1 replicated
ok 13 - tab1_2 updated
ok 14 - check replica update after trigger applied on subscriber
ok 15 - tab1_def unchanged
Waiting for replication conn sub1's replay_lsn to pass 0/150D218 on publisher
done
Waiting for replication conn sub2's replay_lsn to pass 0/150D218 on publisher
done
ok 16 - update of tab1 (delete from tab1_def + insert into tab1_1) replicated
ok 17 - updates of tab1 (delete + insert) replicated into tab1_2_2 correctly
ok 18 - tab1_1 unchanged
ok 19 - insert into tab1_2 replicated
ok 20 - delete from tab1_def replicated
Waiting for replication conn sub1's replay_lsn to pass 0/150D378 on publisher
done
Waiting for replication conn sub2's replay_lsn to pass 0/150D378 on publisher
done
ok 21 - delete from tab1_1, tab1_2 replicated
ok 22 - delete from tab1_1 replicated
ok 23 - delete from tab1_2 replicated
Waiting for replication conn sub1's replay_lsn to pass 0/150E0C8 on publisher
done
Waiting for replication conn sub2's replay_lsn to pass 0/150E0C8 on publisher
done
ok 24 - truncate of tab1_2 replicated
ok 25 - truncate of tab1_2 replicated
Waiting for replication conn sub1's replay_lsn to pass 0/15129B8 on publisher
done
Waiting for replication conn sub2's replay_lsn to pass 0/15129B8 on publisher
done
ok 26 - truncate of tab1_1 replicated
ok 27 - truncate of tab1 replicated
### Reloading node "subscriber1"
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_subscriber1_data/pgdata reload
server signaled
Waiting for replication conn sub1's replay_lsn to pass 0/1512C88 on publisher
done
Waiting for replication conn sub2's replay_lsn to pass 0/1512C88 on publisher
done
Waiting for replication conn sub1's replay_lsn to pass 0/1512E30 on publisher
done
Waiting for replication conn sub2's replay_lsn to pass 0/1512E30 on publisher
done
ok 28 - update target row is missing in tab1_2_2
ok 29 - delete target row is missing in tab1_1
ok 30 - delete target row is missing in tab1_2_2
ok 31 - delete target row is missing in tab1_def
### Reloading node "subscriber1"
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_subscriber1_data/pgdata reload
server signaled
#### Begin standard error
psql:<stdin>:1: NOTICE:  dropped replication slot "sub1" on publisher
#### End standard error
#### Begin standard error
psql:<stdin>:1: NOTICE:  created replication slot "sub_viaroot" on publisher
#### End standard error
ok 32 - initial data synced for pub_viaroot
Waiting for replication conn sub_viaroot's replay_lsn to pass 0/153E3E0 on publisher
done
Waiting for replication conn sub2's replay_lsn to pass 0/153E3E0 on publisher
done
ok 33 - inserts into tab2 replicated
ok 34 - inserts into tab3_1 replicated
ok 35 - inserts into tab1 replicated
ok 36 - inserts into tab2 replicated
ok 37 - inserts into tab3 replicated
ok 38 - inserts into tab4 replicated
ok 39 - inserts into tab4_1 replicated
Waiting for replication conn sub2's replay_lsn to pass 0/153E490 on publisher
done
ok 40 - inserts into tab4 replicated
ok 41 - inserts into tab4_1 replicated
Waiting for replication conn sub_viaroot's replay_lsn to pass 0/153E6D0 on publisher
done
Waiting for replication conn sub2's replay_lsn to pass 0/153E6D0 on publisher
done
ok 42 - update of tab2 replicated
ok 43 - update of tab3_1 replicated
ok 44 - inserts into tab1 replicated
ok 45 - inserts into tab2 replicated
ok 46 - inserts into tab3 replicated
Waiting for replication conn sub_viaroot's replay_lsn to pass 0/153E970 on publisher
done
Waiting for replication conn sub2's replay_lsn to pass 0/153E970 on publisher
done
ok 47 - update of tab2 replicated
ok 48 - update of tab3_1 replicated
ok 49 - update of tab1 replicated
ok 50 - update of tab2 replicated
ok 51 - update of tab3 replicated
Waiting for replication conn sub_viaroot's replay_lsn to pass 0/153ED00 on publisher
done
Waiting for replication conn sub2's replay_lsn to pass 0/153ED00 on publisher
done
ok 52 - delete tab2 replicated
ok 53 - delete from tab1 replicated
ok 54 - delete from tab2 replicated
ok 55 - delete from tab3 replicated
Waiting for replication conn sub_viaroot's replay_lsn to pass 0/15419A8 on publisher
done
Waiting for replication conn sub2's replay_lsn to pass 0/15419A8 on publisher
done
ok 56 - truncate of tab2_1 NOT replicated
ok 57 - truncate of tab1_2 NOT replicated
ok 58 - truncate of tab2_1 NOT replicated
Waiting for replication conn sub_viaroot's replay_lsn to pass 0/15465C8 on publisher
done
Waiting for replication conn sub2's replay_lsn to pass 0/15465C8 on publisher
done
ok 59 - truncate of tab2 replicated
ok 60 - truncate of tab1 replicated
ok 61 - truncate of tab2 replicated
ok 62 - truncate of tab3 replicated
ok 63 - truncate of tab3_1 replicated
Waiting for replication conn sub_viaroot's replay_lsn to pass 0/1549888 on publisher
done
Waiting for replication conn sub2's replay_lsn to pass 0/1549888 on publisher
done
ok 64 - inserts into tab2 replicated
ok 65 - inserts into tab2 replicated
### Reloading node "subscriber1"
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_subscriber1_data/pgdata reload
server signaled
Waiting for replication conn sub_viaroot's replay_lsn to pass 0/1549980 on publisher
done
Waiting for replication conn sub2's replay_lsn to pass 0/1549980 on publisher
done
ok 66 - update target row is missing in tab2_1
ok 67 - delete target row is missing in tab2_1
1..67
### Stopping node "publisher" using mode immediate
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_publisher_data/pgdata -m immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "publisher"
### Stopping node "subscriber1" using mode immediate
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_subscriber1_data/pgdata -m immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "subscriber1"
### Stopping node "subscriber2" using mode immediate
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_013_partition_subscriber2_data/pgdata -m immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "subscriber2"
