# Checking port 56861
# Found port 56861
Name: publisher
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_031_column_list_publisher_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_031_column_list_publisher_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_031_column_list_publisher_data/archives
Connection string: port=56861 host=/tmp/f8ZcoYrTqU
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/031_column_list_publisher.log
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_031_column_list_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_031_column_list_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_031_column_list_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_031_column_list_publisher_data/pgdata
### Starting node "publisher"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_031_column_list_publisher_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/031_column_list_publisher.log -o --cluster-name=publisher start
waiting for server to start.... done
server started
# Postmaster PID for node "publisher" is 18809092
# Checking port 56862
# Found port 56862
Name: subscriber
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_031_column_list_subscriber_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_031_column_list_subscriber_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_031_column_list_subscriber_data/archives
Connection string: port=56862 host=/tmp/f8ZcoYrTqU
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/031_column_list_subscriber.log
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_031_column_list_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_031_column_list_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_031_column_list_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_031_column_list_subscriber_data/pgdata
### Starting node "subscriber"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_031_column_list_subscriber_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/031_column_list_subscriber.log -o --cluster-name=subscriber start
waiting for server to start.... done
server started
# Postmaster PID for node "subscriber" is 1245756
ok 1 - publication relation updated
#### Begin standard error
psql:<stdin>:2: NOTICE:  created replication slot "sub1" on publisher
#### End standard error
ok 2 - insert on column tab1.c is not replicated
ok 3 - insert on column tab3.b is not replicated
ok 4 - insert on column tab4.c is not replicated
ok 5 - insert on column test_part.c columns is not replicated
Waiting for replication conn sub1's replay_lsn to pass 0/1526540 on publisher
done
ok 6 - insert on column tab1.c is not replicated
ok 7 - insert on column tab3.b is not replicated
ok 8 - insert on column tab4.c is not replicated
ok 9 - insert on column test_part.c columns is not replicated
Waiting for replication conn sub1's replay_lsn to pass 0/1526868 on publisher
done
ok 10 - only update on column tab1.b is replicated
ok 11 - only update on column tab3.c is replicated
ok 12 - update on column tab4.c is not replicated
Waiting for replication conn sub1's replay_lsn to pass 0/1527148 on publisher
done
ok 13 - insert on column tab2.c is not replicated
Waiting for replication conn sub1's replay_lsn to pass 0/1527248 on publisher
done
ok 14 - update on column tab2.c is not replicated
Waiting for replication conn sub1's replay_lsn to pass 0/152AE88 on publisher
done
Waiting for replication conn sub1's replay_lsn to pass 0/152AFF8 on publisher
done
ok 15 - overlapping publications with overlapping column lists
Waiting for replication conn sub1's replay_lsn to pass 0/152B818 on publisher
done
ok 16 - overlapping publications with overlapping column lists
Waiting for replication conn sub1's replay_lsn to pass 0/152ECC8 on publisher
done
ok 17 - replication with the original primary key
Waiting for replication conn sub1's replay_lsn to pass 0/15304E8 on publisher
done
ok 18 - replication with the modified primary key
Waiting for replication conn sub1's replay_lsn to pass 0/15338A8 on publisher
done
ok 19 - replication with the original primary key
Waiting for replication conn sub1's replay_lsn to pass 0/1535388 on publisher
done
ok 20 - replication with the modified primary key
Waiting for replication conn sub1's replay_lsn to pass 0/1536F48 on publisher
done
ok 21 - replication with the modified primary key
Waiting for replication conn sub1's replay_lsn to pass 0/1546CB8 on publisher
done
ok 22 - partitions with different replica identities not replicated correctly
Waiting for replication conn sub1's replay_lsn to pass 0/1553458 on publisher
done
ok 23 - partitions with different replica identities not replicated correctly
#### Begin standard error
psql:<stdin>:2: NOTICE:  dropped replication slot "sub1" on publisher
psql:<stdin>:3: NOTICE:  created replication slot "sub1" on publisher
#### End standard error
Waiting for replication conn sub1's replay_lsn to pass 0/15645C8 on publisher
done
ok 24 - partitions with different replica identities not replicated correctly
Waiting for replication conn sub1's replay_lsn to pass 0/1567228 on publisher
done
ok 25 - partitions with different replica identities not replicated correctly
Waiting for replication conn sub1's replay_lsn to pass 0/156CCE0 on publisher
done
ok 26 - partitions with different replica identities not replicated correctly
Waiting for replication conn sub1's replay_lsn to pass 0/15706B8 on publisher
done
ok 27 - a mix of publications should use a union of column list
Waiting for replication conn sub1's replay_lsn to pass 0/15B6C90 on publisher
done
ok 28 - a mix of publications should use a union of column list
#### Begin standard error
psql:<stdin>:2: NOTICE:  dropped replication slot "sub1" on publisher
#### End standard error
#### Begin standard error
psql:<stdin>:2: NOTICE:  created replication slot "sub1" on publisher
#### End standard error
Waiting for replication conn sub1's replay_lsn to pass 0/15BBC38 on publisher
done
ok 29 - a mix of publications should use a union of column list
#### Begin standard error
psql:<stdin>:2: NOTICE:  dropped replication slot "sub1" on publisher
#### End standard error
#### Begin standard error
psql:<stdin>:2: NOTICE:  created replication slot "sub1" on publisher
#### End standard error
Waiting for replication conn sub1's replay_lsn to pass 0/15C5BE0 on publisher
done
ok 30 - publication via partition root applies column list
Waiting for replication conn sub1's replay_lsn to pass 0/15CB3E8 on publisher
done
ok 31 - two publications, publishing the same relation
Waiting for replication conn sub1's replay_lsn to pass 0/15CB460 on publisher
done
ok 32 - two publications, publishing the same relation
#### Begin standard error
psql:<stdin>:2: NOTICE:  drop cascades to table s1.t
#### End standard error
#### Begin standard error
psql:<stdin>:2: NOTICE:  drop cascades to table s1.t
#### End standard error
Waiting for replication conn sub1's replay_lsn to pass 0/15D7E68 on publisher
done
ok 33 - publication containing both parent and child relation
Waiting for replication conn sub1's replay_lsn to pass 0/15E1520 on publisher
done
ok 34 - publication containing both parent and child relation
### Stopping node "subscriber" using mode fast
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_031_column_list_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_031_column_list_publisher_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "publisher"
1..34
