Re: High Availability with Postgres

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: High Availability with Postgres
Date: 2010-06-23 15:33:05
Message-ID: 4C222931.3000706@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-06-23 15:33:10 Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE
Previous Message Grzegorz Jaśkiewicz 2010-06-23 15:31:40 Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE