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> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: johnf@jfcomputer.com
Subject: Re: syncing - between databases
In-Reply-To: <1545853.rUp5XqBn04@linux-12>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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