Re: replication in Postgres - Mailing list pgsql-general

From Vivek Khera
Subject Re: replication in Postgres
Date
Msg-id 6B7F63E4-1D2F-4506-930F-31306D4CFBF1@khera.org
Whole thread Raw
In response to Re: replication in Postgres  ("Jeff Larsen" <jlar310@gmail.com>)
Responses Re: replication in Postgres  ("Jeff Larsen" <jlar310@gmail.com>)
List pgsql-general
On Nov 26, 2007, at 10:14 AM, Jeff Larsen wrote:

> Yes, but I'd like something better than "near real time" as the above
> page describes. Or maybe someone could clarify that.... Besides,
> EnterpriseDB does not save me enough money. In my current commercial
> DB, if a transaction is committed on the master, it is guaranteed to
> be committed to the secondary. In our business, losing one customer
> order could lose us the customer for good.

So you want synchronous replication.  Search on that term in the
archives for possible solutions (or lack thereof) in postgres.

If you don't specify your requirements clearly, don't expect useful
advice ;-)


pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: Migrating from 32 to 64 bit
Next
From: "Jeff Larsen"
Date:
Subject: Re: replication in Postgres