0

If I have a master node 1 (with database A) and a master node 2 (with database B) can I use repmgr and have both A and B replicated to a hot standby node 3 ?

[ EDIT: They would all be running Postgres 9.3 ]

Improve this question
2
  • 1
    No, I don't think that is possible. because a slave is always a 1:1 copy of the master. There is no way to merge two masters into one slave with Postgres (and remgr doesn't extend the abilities of Postgres' replication, it only makes it easier to use)
    – a_horse_with_no_name
    Sep 6, 2014 at 7:53
  • Thanks for the comment. If you want, move it to an answer so that I can close the question with one.
    – adamo
    Sep 7, 2014 at 7:15

1 Answer 1

Reset to default
3

PostgreSQL's built-in replication (as used by repmgr) replicates entire PostgreSQL instances - with all databases. The transaction log is shared between all databases.

PostgreSQL can't merge transaction logs from another instance. Nor can it replicate only a subset of databases. You have to replicate exactly one instance to exactly one other instance.

If you want something other than that, there are a variety of other replication options such as Londiste, Slony-I, BDR, etc.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.