Re: Postgresql replication - Mailing list pgsql-general

From Michael Meskes
Subject Re: Postgresql replication
Date
Msg-id 200508241531.34314.meskes@postgresql.org
Whole thread Raw
In response to Postgresql replication  (Carlos Henrique Reimer <carlosreimer@yahoo.com.br>)
List pgsql-general
Am Mittwoch, 24. August 2005 14:21 schrieb Carlos Henrique Reimer:
> One possible solution is replicate the headquarter DB into the two
> branches.
>
> I read about slony-i, but then the replicated DBs will be read-only.

That's because it's a master-slave replication. If you could sync the slave
back to the master it would be a master itself.

> I think I´m looking for a master-slave assynchronous solution. I know
> pgReplicator can do it, but I think the project is not active any more.

But Slony does master/slave replication.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

pgsql-general by date:

Previous
From: Jose Gonzalez Gomez
Date:
Subject: Re: [OT?] ETL tools
Next
From: "Welty, Richard"
Date:
Subject: Re: Postgresql replication