Thread: 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.