...

In each facility you have a database server up and running with Postgres installed.

Create primary database server

...

1. change postgres.conf to enable networking

2. create a replication user

3. allow remote access in pg_hba.conf
   

...

vim /var/lib/postgresql/daselement-munich/postgres.conf

# uncomment and change the line:
listen_addresses = '*'

# and change the port to 5433 to avoid conflicts with any default instances that are running on port 5432
port = 5433

# start the Postgres server
pg_ctl -D /var/lib/postgresql/daselement-datamunich start

Create a user accounts

...

In the other facility import the library (.lib) from main facility.
Make sure to lock the library (Lock Library option) to prevent editing and ingesting of new elements!

Advanced Setup

If you want to take it a step further it’s a good idea to look into these topics:

• high availability

• load balancing

• connection pooling

• automatic fail-over
  

Here is a great video tutorial using PGPool-II to deal with these topics.

Monitoring

...