Re: clustering

#1

Google "slony"

Regards,
aaron.glenn

On Thu, 14 Oct 2004 10:29:11 +0530, Nageshwar Rao
<nageshwarr (AT) planetasia (DOT) com> wrote:

Quote:

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.

Thanks

Nageshwar Rao

91-80-25522059

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#2

On Thu, Oct 14, 2004 at 10:29:11AM +0530, Nageshwar Rao wrote:

Quote:

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 | ajs (AT) crankycanuck (DOT) ca
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 majordomo (AT) postgresql (DOT) org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: clustering

comp.databases.postgresql.general comp.databases.postgresql.general

Re: clustering - 10-19-2004 , 12:39 AM

Re: clustering - 10-19-2004 , 09:43 AM