Advice on HA option
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?
Thank you for all the suggestions.
Helen
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Advice-on-HA-option-tp4775605p4775605.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
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
Thank you, I will look at skype's walmgr.
Also could you explain what makes it "hands free administration" 9.0?
Is the shipping of the wal file from the master to HA instance automated ?
Any error checking /self recovery?
thank you much for the suggestion.
Helen
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Advice-on-HA-option-tp4775605p4779672.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.