LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   Best practice for postgresql 9.1 DB replication for cold standby purpose (https://www.linuxquestions.org/questions/linux-software-2/best-practice-for-postgresql-9-1-db-replication-for-cold-standby-purpose-926853/)

NicholasHee 02-01-2012 02:40 AM

Best practice for postgresql 9.1 DB replication for cold standby purpose
 
Hi All,

I m seeking a solution for my postgresql DB replication. After several days of browsing found that postgresql come with alot of option in term of replication solution eg: slony + pgpool , postgresql 9.1 streaming replication + pgpool or pg_cluster, and many others.

but i just need a simple requirement of this replication project

Background info

currently i have two postgres 9.1 servers each with 5 different database.

Requirement

1. I wish to replicate both servers' DBs vice versa as cold standby purpose i dont need auto failover.

2. good to have if i can choose which DBs to replicate over another server.

3. Simple set up is preferred



Regards
Nicholas


All times are GMT -5. The time now is 01:09 AM.