Re: Advice on HA option - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Advice on HA option
Date
Msg-id CAHyXU0yd6dWK3EhQ=4M4w+ax5AHS4MotNPJoYUd+YKhHGA27Pg@mail.gmail.com
Whole thread Raw
In response to Advice on HA option  (hyelluas <helen_yelluas@mcafee.com>)
Responses Re: Advice on HA option
List pgsql-general
On Tue, Sep 6, 2011 at 2:06 PM, hyelluas <helen_yelluas@mcafee.com> wrote:
> Hello,
>
> I need to implement HA for the appliance that is sold to the customer  - our
> application has no DBA and must be very stable and self  recoverable.
>
> We are running PostgreSQL 8.4.
>
> Is the warm standby a good solution for us?

It can work, but hands free administration will be a lot easier with
9.0 SR -- perhaps enough so to justify looking at an upgrade.  If you
are stuck on 8.4, take a look at some helper tools, such as skype's
walmgr.

merlin

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: conditional insert
Next
From: Chris Redekop
Date:
Subject: Re: Demoting master to slave without an rsync...is it safe?