Page Comparison

...

1. Create subscriber database cluster

2. copy database Schema from the primary database

3. create subscription to primary database

1 creat create database

Now let’s setup a database in a different facility

...

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.

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

# create 

3 create subscription

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

...