Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Now create a new library inside the software. Use the dbuser to connect to the databas.

...

We Hurray, we have the main library for facility Munich running.

...

Configure subscriber server

  1. Create subscriber database cluster

  2. copy database Schema from the primary database

  3. create subscription to primary database

1 creat database

Now let’s setup a database in a different facility

Code Block
# 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

2 copy schema

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.

3 create subscription

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

...