...
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
Create subscriber database cluster
copy database Schema from the primary database
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.
...