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-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--=-3pGbdaKWuw+agYL/3+hT
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

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 [at] gmail.com>
Reply-to: dclements89 [at] gmail.com
To: pgsql-admin [at] postgresql.org, pgsql-sql <pgsql-sql [at] 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

--=-3pGbdaKWuw+agYL/3+hT
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.28.1">
</HEAD>
<BODY>
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 <<A HREF="mailto:Dave%20Clements%20%3cdclements89 [at] gmail.com%3e">dclements89 [at] gmail.com</A>> 
Reply-to: dclements89 [at] gmail.com 
To: <A HREF="mailto:pgsql-admin [at] postgresql.org">pgsql-admin [at] postgresql.org</A>, pgsql-sql <<A HREF="mailto:pgsql-sql%20%3cpgsql-sql [at] postgresql.org%3e">pgsql-sql [at] postgresql.org</A>> 
Subject: [ADMIN] PostgreSQL Active-Active Configuration 
Date: Fri, 5 Mar 2010 18:25:24 +1100 
 
<PRE>
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

</PRE>
 
</BODY>
</HTML>

--=-3pGbdaKWuw+agYL/3+hT--

--=-NDk1WTSDH8FgLAgFrA6R
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, 2010-03-05 at 09:20 +0100, I=C3=B1igo 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=C3=9CND=C3=9CZ
PostgreSQL Dan=C4=B1=C5=9Fman=C4=B1/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

--=-NDk1WTSDH8FgLAgFrA6R
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEABECAAYFAkuQv90ACgkQtl86P3SPfQ5vNQCdFpmqTlr+5dNrwqL8Pvxg h32c
qWcAoJm+8N+A2ysGkNup9L17GxqxPmCw
=DfC+
-----END PGP SIGNATURE-----

--=-NDk1WTSDH8FgLAgFrA6R--

You may want to try Bucardo ... By performance, are you referring to late=
ncy? If so, bandwidth between sites typically is the factor with latency i=
n any replication solution.

http://bucardo.org/

-----Original Message-----
From: pgsql-sql-owner [at] postgresql.org [mailto:pgsql-sql-owner [at] postgresql.org=
] On Behalf Of Dave Clements
Sent: Friday, March 05, 2010 1:25 AM
To: pgsql-admin [at] 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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

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

PostgreSQL Active-Active Configuration

Re: PostgreSQL Active-Active Configuration

Re: [ADMIN] PostgreSQL Active-Active Configuration

Re: PostgreSQL Active-Active Configuration