Re: replication/redundancy - Mailing list pgsql-admin

From Toni Schlichting
Subject Re: replication/redundancy
Date
Msg-id 3EFEA338.7000307@schlichting.net
Whole thread Raw
In response to Re: replication/redundancy  (weigelt@metux.de)
Responses Re: replication/redundancy  (Jonathan Gardner <jgardner@jonathangardner.net>)
List pgsql-admin

weigelt@metux.de wrote:

>On Fri, Jun 27, 2003 at 08:05:02PM -0400, Dave [Hawk-Systems] wrote:
>
>
>>some searches on this have produced mixed results...
>>
>>do we have a stable means to replicate transactions between two physical
>>servers, preferrably in master - master configuration where updates/inserts can
>>be done on either database and the results replicated to the other master.
>>
I fear up to date there is no such facility available. As far as I have
understood
your question you intend to copy all transactions from database-A to
database-B and
continously rollforward database-B, or so.

It seems pgreplication will be the tool you are looking. it is under way
but it is
not here yet. It looks as if pgreplication will do much more than just
enabling a
hot standby. What I have read up to now looks more like a
quorum-facility. I hope,
I didn't get this wrong, because I would have use for something like this.

Ciao, Toni



pgsql-admin by date:

Previous
From: weigelt@metux.de
Date:
Subject: Re: replication/redundancy
Next
From: "Daniel Seichter"
Date:
Subject: postgreSQL users = LDAP users?