# Checking port 55771
# Found port 55771
Name: publisher
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_027_nosuperuser_publisher_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_027_nosuperuser_publisher_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_027_nosuperuser_publisher_data/archives
Connection string: port=55771 host=/tmp/LLrYZ4Aqoh
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/027_nosuperuser_publisher.log
# Checking port 55772
# Found port 55772
Name: subscriber
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_027_nosuperuser_subscriber_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_027_nosuperuser_subscriber_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_027_nosuperuser_subscriber_data/archives
Connection string: port=55772 host=/tmp/LLrYZ4Aqoh
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/027_nosuperuser_subscriber.log
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_027_nosuperuser_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_027_nosuperuser_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_027_nosuperuser_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_027_nosuperuser_publisher_data/pgdata
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_027_nosuperuser_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_027_nosuperuser_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_027_nosuperuser_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_027_nosuperuser_subscriber_data/pgdata
### Starting node "publisher"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_027_nosuperuser_publisher_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/027_nosuperuser_publisher.log -o --cluster-name=publisher start
waiting for server to start.... done
server started
# Postmaster PID for node "publisher" is 4653678
### Starting node "subscriber"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_027_nosuperuser_subscriber_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/027_nosuperuser_subscriber.log -o --cluster-name=subscriber start
waiting for server to start.... done
server started
# Postmaster PID for node "subscriber" is 60621172
#### Begin standard error
psql:<stdin>:3: NOTICE:  created replication slot "admin_sub" on publisher
#### End standard error
Waiting for replication conn admin_sub's replay_lsn to pass 0/14EFD00 on publisher
done
Waiting for replication conn admin_sub's replay_lsn to pass 0/14EFFB0 on publisher
done
ok 1 - superuser admin replicates into unpartitioned
ok 2 - non-superuser admin fails to replicate update
Waiting for replication conn admin_sub's replay_lsn to pass 0/14F0048 on publisher
done
ok 3 - admin with restored superuser privilege replicates update
Waiting for replication conn admin_sub's replay_lsn to pass 0/14F00B8 on publisher
done
ok 4 - nosuperuser admin with INSERT privileges can replicate into unpartitioned
ok 5 - non-superuser admin without SELECT privileges fails to replicate update
Waiting for replication conn admin_sub's replay_lsn to pass 0/14F01A8 on publisher
done
ok 6 - nosuperuser admin with all table privileges can replicate into unpartitioned
Waiting for replication conn admin_sub's replay_lsn to pass 0/14F0418 on publisher
done
ok 7 - nosuperuser admin with all table privileges can replicate into hashpart
ok 8 - non-superuser admin fails to replicate insert into rls enabled table
Waiting for replication conn admin_sub's replay_lsn to pass 0/14F0488 on publisher
done
ok 9 - admin with restored superuser privilege replicates insert into rls enabled unpartitioned
ok 10 - non-superuser admin fails to replicate update into rls enabled unpartitioned
Waiting for replication conn admin_sub's replay_lsn to pass 0/14F0508 on publisher
done
ok 11 - admin with bypassrls replicates update into rls enabled unpartitioned
ok 12 - non-superuser admin without bypassrls fails to replicate delete into rls enabled unpartitioned
Waiting for replication conn admin_sub's replay_lsn to pass 0/14F0578 on publisher
done
ok 13 - admin with bypassrls replicates delete into rls enabled unpartitioned
Waiting for replication conn admin_sub's replay_lsn to pass 0/14F06D8 on publisher
done
ok 14 - nosuperuser nobypassrls table owner can replicate delete into unpartitioned despite rls
1..14
### Stopping node "publisher" using mode immediate
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_027_nosuperuser_publisher_data/pgdata -m immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "publisher"
### Stopping node "subscriber" using mode immediate
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_027_nosuperuser_subscriber_data/pgdata -m immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "subscriber"
