From: Jeff Hoffmann <jeff@propertykey.com>
To: Aaron J. Seigo <aaron@gtv.ca>
To: pgsql-general@hub.org
Subject: Re: [GENERAL] Re: replication
Date: Tue, 16 Nov 1999 13:33:02 -0600
Message-ID: <3831B16E.F1D48D46@propertykey.com> (raw)
References: <Pine.LNX.4.04.9911161628270.8457-100000@tinago.msuiit.edu.ph>
<99111609264002.18220@stilborne>
<383192A9.AA3E25C4@propertykey.com>
<99111612001404.18220@stilborne>
"Aaron J. Seigo" wrote:
> this needs to be in the back end... otherwise, if you have multiple people
> performing updates on different replicated servers, how can you guarentee
> concurancy? how do you manage the differences between read-only and updateable
> replicants? (this can be done using your wrapper method, but quickly gets
> clumsy)
yeah it can get clumsy, but fortunately updates are pretty rare in my
case (and usually only performed by one person) so i don't really worry
about those issues, but i should. the only safety issue i use is
starting a transaction for each connection, perform the action on all of
the databases, and then commit the transaction on each. it's not bad
unless one of the commits fails and the others don't, then i have to
retry the failed ones & hope it works. i don't know how to fix it if i
had to give up on one of the transactions for a mirror. again, not
perfect, but it works pretty well for me & my simpler cases.
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-general@postgresql.org
Cc: jeff@propertykey.com, aaron@gtv.ca, pgsql-general@hub.org
Subject: Re: [GENERAL] Re: replication
In-Reply-To: <3831B16E.F1D48D46@propertykey.com>
* 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