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