Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
    
i like this one: 'the replication options for PSQL are agricultural to say the least' [ from serverfault.com/questions/11137/postgresql-replication ] ;-] –  pQd Jan 5 '10 at 19:27
    
Yep, I seen this as well. Not very encouraging :( –  SyRenity Jan 6 '10 at 11:56
add comment

1 Answer 1

up vote 4 down vote accepted

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.

share|improve this answer
    
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 '10 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. –  Peter Eisentraut Jan 6 '10 at 21:37
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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