Page Comparison

...

Postgres replication does not support the Postgres Data Definition Language (DLL) commands.
For us this means that we have to copy over the Database Schema from the Primary Database to the subscriber server first. This step only needs to be done once.

# create database from primary database
psql --port=5460 postgres

# create an empty database where the information will be replicated to
create database rep_de_munich_vfxelements

# expected ouptut: CREATE DATABASE

...

Now copy over all the information from the primary to the subscriber. Execute this command on the primary database server.

# use pg_dump to copy the data
pg_dump -s de_munich_vfxelements -p 5432 | psql -h 192.168.178.50 -p 5432 rep_de_munich_vfxelements

...

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

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

...