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