Re: replication in Postgres - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: replication in Postgres
Date
Msg-id 20071126133023.28880988@commandprompt.com
Whole thread Raw
In response to Re: replication in Postgres  (Chris Browne <cbbrowne@acm.org>)
Responses Re: replication in Postgres  ("Garber, Mikhail" <mgarber@amazon.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Mon, 26 Nov 2007 12:39:42 -0500
Chris Browne <cbbrowne@acm.org> wrote:


> Unfortunately, the only way to make things deterministic (or to get
> from "near real time" to "*GUARANTEED* real time") is to jump to
> synchronous replication, which is not much different from 2PC (Two
> Phase Commit), and which is certain to be prohibitively expensive
> across a WAN.
> 
> At this point, I tend to get visions of Tom Cruise telling Jack
> Nicholson, "I want real time replication!", and getting the response:
> "You can't HANDLE real time replication!"

You're damn right I ordered real time replication!

- -- 

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
            UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHSzrvATb/zqfZUUQRAqfwAKCA+p8tzxIQJGrnEm8F7D5H0HbkCQCfTk7J
D0mtHxYmVhXVAfbvUYMO6tw=
=0m/Q
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: replication in Postgres
Next
From: Ron Johnson
Date:
Subject: Re: Primary Key