Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9BA836352C2; Fri, 5 Mar 2010 04:25:34 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 85974-08; Fri, 5 Mar 2010 08:25:24 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gunduz.org (ns1.gunduz.org [77.79.103.58]) by mail.postgresql.org (Postfix) with ESMTP id 0A57D635177; Fri, 5 Mar 2010 04:25:24 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.gunduz.org (Postfix) with ESMTP id 2B47A4003E3; Fri, 5 Mar 2010 10:27:17 +0200 (EET) X-Virus-Scanned: amavisd-new at mail.gunduz.org Received: from mail.gunduz.org ([127.0.0.1]) by localhost (mail.gunduz.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id yvDAPH0Gz6Ei; Fri, 5 Mar 2010 10:27:14 +0200 (EET) Received: from [10.15.1.91] (unknown [88.248.109.177]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.gunduz.org (Postfix) with ESMTPSA id F0675400046; Fri, 5 Mar 2010 10:27:13 +0200 (EET) Subject: Re: PostgreSQL Active-Active Configuration From: Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= To: =?ISO-8859-1?Q?I=F1igo?= Martinez Lasala Cc: dclements89@gmail.com, pgsql-admin@postgresql.org, pgsql-sql In-Reply-To: <1267777259.17535.372.camel@deimos> References: <1f30b80c1003042325s6235405bsc914bb13b74dd577@mail.gmail.com> <1267777259.17535.372.camel@deimos> Content-Type: multipart/signed; micalg="pgp-sha1"; protocol="application/pgp-signature"; boundary="=-NDk1WTSDH8FgLAgFrA6R" Date: Fri, 05 Mar 2010 10:25:05 +0200 Message-ID: <1267777505.2905.2.camel@hp-laptop2.gunduz.org> Mime-Version: 1.0 X-Mailer: Evolution 2.28.2 (2.28.2-1.fc12) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/42 X-Sequence-Number: 33841 --=-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.=20 FWIW, timestamps are rewritten in recent pgpool versions to avoid such issues. However, similar problems exist for serial, etc. -HTH. --=20 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+5dNrwqL8Pvxgh32c qWcAoJm+8N+A2ysGkNup9L17GxqxPmCw =DfC+ -----END PGP SIGNATURE----- --=-NDk1WTSDH8FgLAgFrA6R--