Thread: Two way replication

Two way replication

From
"Anibal David Acosta"
Date:

Hello.

 

I have two postgres 9.0 database both can be modified and both must have same information.

 

In case of collision (same row changed in both) must win the most recent.

 

Thanks.

 

 

Re: Two way replication

From
"Kevin Grittner"
Date:
"Anibal David Acosta" <aa@devshock.com> wrote:

> I have two postgres 9.0 database both can be modified and both
> must have same information.
>
> In case of collision (same row changed in both) must win the most
> recent.

If latency issues don't preclude it, pgpool might work for you.

-Kevin