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. >
Yes. There are a fair number of commercial solutions out there if you're willing to shell out some US$500+ per server. > 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? > Another possibility is to purchase a shared-storage appliance of some kind, patch your kernels with the opengfs patch, and put opengfs on the storage device, and obviously your database runs there. Set it up so that only one database is active with Linux-HA heartbeat. However, the cheapest shared storage appliances (HP StorageWorks MSA SCSI, I think), costs about PhP 100k, IIRC. -- 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
