pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL Active-Active Configuration
4+ messages / 4 participants
[nested] [flat]
* PostgreSQL Active-Active Configuration
@ 2010-03-05 07:25 Dave Clements <dclements89@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Dave Clements @ 2010-03-05 07:25 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL Active-Active Configuration
@ 2010-03-05 08:20 Iñigo Martinez Lasala <imartinez@vectorsf.com>
parent: Dave Clements <dclements89@gmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Iñigo Martinez Lasala @ 2010-03-05 08:20 UTC (permalink / raw)
To: dclements89@gmail.com; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL Active-Active Configuration
@ 2010-03-05 08:25 Devrim GÜNDÜZ <devrim@gunduz.org>
parent: Iñigo Martinez Lasala <imartinez@vectorsf.com>
0 siblings, 0 replies; 4+ messages in thread
From: Devrim GÜNDÜZ @ 2010-03-05 08:25 UTC (permalink / raw)
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>; +Cc: pgsql-sql
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
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] PostgreSQL Active-Active Configuration
@ 2010-03-05 13:58 Plugge, Joe R. <JRPlugge@west.com>
parent: Dave Clements <dclements89@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Plugge, Joe R. @ 2010-03-05 13:58 UTC (permalink / raw)
To: dclements89@gmail.com <dclements89@gmail.com>; pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>; pgsql-sql
You may want to try Bucardo ... By performance, are you referring to latency? If so, bandwidth between sites typically is 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-03-05 13:58 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-05 07:25 PostgreSQL Active-Active Configuration Dave Clements <dclements89@gmail.com>
2010-03-05 08:20 ` Iñigo Martinez Lasala <imartinez@vectorsf.com>
2010-03-05 08:25 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2010-03-05 13:58 ` Plugge, Joe R. <JRPlugge@west.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox