PostgreSQL Administration - Re: postgres in HA constellation

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: postgres in HA constellation

Brad Nicholson

2006-10-25, 8:24 am

On Wed, 2006-10-11 at 16:12 -0500, Jim C. Nasby wrote:
> On Wed, Oct 11, 2006 at 10:28:44AM -0400, Andrew Sullivan wrote:
>
> Hrm... I guess it depends on how quickly the Slony master would stop
> processing if it was talking to a shared-disk that had become corrupt
> from another postmaster.

That doesn't depend on Slony, it depends on Postgres. If transactions
are committing on the master, Slony will replicate them. You could have
a situation where your HA failover trashes some of you database, but the
database still starts up. It starts accepting and replicating
transactions before the corruption is discovered.

Brad.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Sponsored Links