Postgres Pro
Downloads
Home   >   mailing lists

Thread: clustering

clustering

From
Nageshwar Rao
Date:

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

Re: clustering

From
Aaron Glenn
Date:
Google "slony"

Regards,
aaron.glenn


On Thu, 14 Oct 2004 10:29:11 +0530, Nageshwar Rao
<nageshwarr@planetasia.com> 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.
>
>
>
> Thanks
>
> Nageshwar Rao
>
> 91-80-25522059

Re: clustering

From
Andrew Sullivan
Date:
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  | ajs@crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
        --Dennis Ritchie