On Fri, Mar 05, 2004 at 10:19:40AM +0800, Jagi C. Sarcilla wrote: > Is postgresql capable in replicating its database?, sorry for not so > much knowledge in cluster and high availability. the idea is this. > > i have 2 servers, both running postgresql. and i want it to have > fail-over i case one server goes down the other can take-over the job. > and when the failed server goes up again, it will syncronize its data, > meaning updating the failed server data. is it possible in my plan? > > kindly give suggestion, and help. I would highly appreciated. > > guys i've read your post, thanks
If you REALLY read my long reply to your message and checked the links in the bottom and did some reading you would have seen that this is EXACTLY what at least the first approach does. It goes beyond just PostgreSQL: it replicates ALL your data so its applicable for file and mail servers as well, to name a few. I found more alternative replication approaches for PostgreSQL in GBorg[1]. Check them out, too. (PS: If you, or anybody, needs commercial help with setting up high-availability server clusters let me know by private email and we'll discuss your requirements off-list.) --> Jijo [1] http://gborg.postgresql.org/genpage?replication_research -- Federico Sevilla III : Free & Open Source Software : When we speak of free http://jijo.free.net.ph : Consultant & Administrator : software we refer to GnuPG Key ID : 0x93B746BE : freedom, not price. -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
