3

I'm planning to migrate from MySQL to PostgreSQL, but worried about the apparent luck of replications solutions there.

Are there any current replication techniques that can be used out of box?

Heartbeat/DRBD would probably work, but I'm looking for approaches that are more integrated in PostgreSQL itself.

2

1 Answer 1

4

For available replication solutions, see for instance http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling.

But no, there is nothing at the moment that works "out of the box".

PostgreSQL 8.5, currently in development, will contain a built-in replication feature that is known under the name "Hot Standby". See for example http://www.postgresql.org/about/news.1172.

2
  • This looks interesting - will the switch be automatic, and the "hot standby" node will become the master? Also any ETA for the 8.5 stable? Thanks.
    – SyRenity
    Jan 6, 2010 at 11:57
  • No, the hot standby feature only arranges the replication of the data and receives notice when the slave should become the master. But you will have to trigger the switching yourself, using Heartbeat or UCARP or something like that. It's not exactly plug-and-play. Jan 6, 2010 at 21:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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