pg.ddx.io pgsql-admin@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>
2010-03-05 08:20 ` Re: PostgreSQL Active-Active Configuration Iñigo Martinez Lasala <imartinez@vectorsf.com>
2010-03-05 13:58 ` Re: [SQL] PostgreSQL Active-Active Configuration Plugge, Joe R. <JRPlugge@west.com>
0 siblings, 2 replies; 4+ messages in thread
From: Dave Clements @ 2010-03-05 07:25 UTC (permalink / raw)
To: pgsql-admin@postgresql.org, pgsql-sql <pgsql-sql@postgresql.org>
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 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 ` Re: PostgreSQL Active-Active Configuration Devrim GÜNDÜZ <devrim@gunduz.org>
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-admin@postgresql.org, pgsql-sql <pgsql-sql@postgresql.org>
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 07:25 PostgreSQL Active-Active Configuration Dave Clements <dclements89@gmail.com>
2010-03-05 08:20 ` Re: PostgreSQL Active-Active Configuration Iñigo Martinez Lasala <imartinez@vectorsf.com>
@ 2010-03-05 08:25 ` Devrim GÜNDÜZ <devrim@gunduz.org>
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: dclements89@gmail.com, pgsql-admin@postgresql.org, pgsql-sql <pgsql-sql@postgresql.org>
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 07:25 PostgreSQL Active-Active Configuration Dave Clements <dclements89@gmail.com>
@ 2010-03-05 13:58 ` Plugge, Joe R. <JRPlugge@west.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; pgsql-sql <pgsql-sql@postgresql.org>
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