Confirmed and added to opened items - this is a live bug back to v10.
for a in data data1; do ./tmp_install/usr/local/pgsql/bin/initdb -D $a
--no-sync& done; wait
echo "wal_level = logical">> data/postgresql.conf; echo "port=5433" >>
data1/postgresql.conf
for a in data data1; do ./tmp_install/usr/local/pgsql/bin/postmaster -D $a& done
for a in "CREATE TABLE pgbench_accounts(a int primary key, b int)" "ALTER TABLE
pgbench_accounts REPLICA IDENTITY FULL" "CREATE PUBLICATION mypub FOR TABLE
pgbench_accounts"; do \
for p in 5432 5433; do psql -d postgres -h /tmp -p "$p" -c "$a"; done;
done
psql -d postgres -h /tmp -p 5433 -c "CREATE SUBSCRIPTION mysub CONNECTION
'host=127.0.0.1 port=5432 dbname=postgres' PUBLICATION mypub"
psql -d postgres -h /tmp -p 5432 -c "insert into pgbench_accounts values(1,2);
update pgbench_accounts set b=30 where a=1;"
--
Justin
