Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] PostgreSQL Active-Active Configuration - Mailing list pgsql-sql

From Devrim GÜNDÜZ
Subject Re: [ADMIN] PostgreSQL Active-Active Configuration
Date
Msg-id 1267777505.2905.2.camel@hp-laptop2.gunduz.org
Whole thread Raw
In response to PostgreSQL Active-Active Configuration  (Dave Clements <dclements89@gmail.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Dave Clements
Date:
Subject: PostgreSQL Active-Active Configuration
Next
From: silly sad
Date:
Subject: client_timezone to server_timezone and reverse