On Thu, Oct 14, 2004 at 10:29:11AM +0530, Nageshwar Rao wrote: > Hi, > We would like use Postgresql as our database. For high availability is it > possible to cluster DB in Postgresql. Appreciate if you can let me know how > this can be achieved. > Else is there any other way to achieve High Availability in POstgresql as > this is mission critical system.
My recommendation for HA PostgreSQL is to use two servers with one of those nifty HA options, and let the postmaster on the taking-over machine recover the database just like after a crash. Also, you'll be wanting to use slony (www.slony.info). If you're asking whether Postgres has something akin to Oracle's RAC, the answer is "not yet". A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary and imaginative work need not end up well. --Dennis Ritchie ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]