Page Comparison

...

# create publication for all tables
create publication muc_pub for all tables;

# the expected output is: CREATE PUBLICATION

Configure subscriber server

...

# create database cluster
initdb -D /var/lib/postgresql/daselement-munich_subscription

# start the database cluster
pg_ctl -D /var/lib/postgresql/daselement-munich_subscription start

The last step is now to subscribe to the other facility publication.

dbname = name of the database in the munich facility (muc_pub)

host = ip-of-publisher-postgres-server (e.g. the munich postgres server)

create subscription muc_subscription connection 'dbname=de_munich_vfxelements host=192.168.178.50 user=dbuser port=5433' publication muc_pub;

Configure Logical Replication

...