Re: High Availability with Postgres - Mailing list pgsql-general

From Craig Ringer
Subject Re: High Availability with Postgres
Date
Msg-id 4C222931.3000706@postnewspapers.com.au
Whole thread Raw
In response to Re: High Availability with Postgres  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
On 23/06/10 03:05, John R Pierce wrote:

> yeah.  generally when money is involved in the transactions, you gotta
> stick to the 'no committed data lost ever'.  there's plenty of other use
> cases for that too.

2PC is sometimes a reasonable alternative to shared-storage failover,
though. It can be a lot slower, but it lets you maintain the machines as
completely separate systems with no shared failure points.

--
Craig Ringer

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE
Next
From: Thom Brown
Date:
Subject: Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE