• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 515
  • Last Modified:

postgresql mirror of two databases over openvpn

We are looking at the following option:

1. two server, one on primary site, one secondary site
2. openvpn to communicate over the internet between the two site
3. one postgresql database on each site
4. we would set-up clustering between tabels of both databases.

Has anybody done something similar ??

Is this feasible regarding response time.
Our solution rocks on a single site,
but I fear we will get long response times.

We can live with a small lead time of the information being availble on the remote site.

1 Solution
jhoninck1Author Commented:
In the mean time I have found that probably the best way of achieving this is to use dbmirror,
anybody has any experiences with it ?

dbmirror is based on database triggers that do remote updates as the data of the original table is changed,
looks like that maintains the transactional integrity providing the tables have a primary key.

don't know anything about its performance.
Try Mammuth PostgreSQL Replicator. Great tool.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now