Thread: PostgreSQL Active-Active Configuration

Hi everyone,

I am looking for some Master-Master replication solutions for
PostgreSQL database. Please let me know if you are using one and if
you are happy with the performance.



Thanks

Until now, the only solution that has worked for us is pg_pool, but is not always possible to use it.
For example, if you use functions or sentences that make use of timestamp, random, etc it won't be possible to use pg_pool since each node will have a different value.
If not, it could probably work for you.

-----Original Message-----
From: Dave Clements <dclements89@gmail.com>
Reply-to: dclements89@gmail.com
To: pgsql-admin@postgresql.org, pgsql-sql <pgsql-sql@postgresql.org>
Subject: [ADMIN] PostgreSQL Active-Active Configuration
Date: Fri, 5 Mar 2010 18:25:24 +1100

Hi everyone,

I am looking for some Master-Master replication solutions for
PostgreSQL database. Please let me know if you are using one and if
you are happy with the performance.



Thanks

On Fri, 2010-03-05 at 09:20 +0100, Iñigo Martinez Lasala wrote:
> For example, if you use functions or sentences that make use of
> timestamp, random, etc it won't be possible to use pg_pool since each
> node will have a different value.
> If not, it could probably work for you.

FWIW, timestamps are rewritten in recent pgpool versions to avoid such
issues.

However, similar problems exist for serial, etc.

-HTH.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

You may want to try Bucardo ...   By performance, are you referring to latency?  If so, bandwidth between sites
typicallyis the factor with latency in any replication solution. 

http://bucardo.org/


-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Dave Clements
Sent: Friday, March 05, 2010 1:25 AM
To: pgsql-admin@postgresql.org; pgsql-sql
Subject: [SQL] PostgreSQL Active-Active Configuration

Hi everyone,

I am looking for some Master-Master replication solutions for
PostgreSQL database. Please let me know if you are using one and if
you are happy with the performance.



Thanks

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql