From: John Fabiani <johnf@jfcomputer.com>
To: pgsql-sql@postgresql.org
Subject: syncing - between databases
Date: Sat, 12 May 2012 07:28:16 -0700
Message-ID: <1545853.rUp5XqBn04@linux-12>
User-Agent: KMail/4.7.2 (Linux/3.1.10-1.9-desktop; KDE/4.7.2; x86_64; ; )
MIME-Version: 1.0
Content-Transfer-Encoding: 7Bit
Content-Type: text/plain; charset="us-ascii"

I need to maintain a sync-ed table across several databases.  For example I 
have a customer table in 5 databases.  If a user of any of the databases 
inserts a new customer I need to insert the new record into the other four 
databases.  But question is updates and deletes.

I can use a trigger and dblink to update the other databases when the action 
is an insert because in each of the other databases I don't have to worry 
about a locked record.  But what happens if a user is updating at the same 
moment as a different user in a different database is updating the same 
customer.  Can a race condition occur?

I was thinking I could create a master database.  And have all the other 
databases use dblink to excute the master trigger. 


Any advise would be helpful,

Johnf