On Thu, Aug 19, 2010 at 05:40:21AM +0200, Adrian von Bidder wrote: > On Thursday 19 August 2010 01.32:06 Benjamin Smith wrote: > > This way we can be sure that either all the databases are in synch, or > > that we need to rollback the program patch/update. > > I guess this might be more a hack than a solution: do the updates in batches > and use 2pc: first connect to batches of databases, but instead of commit, > you "prepare to commit". Prepared commits like this are persistent accross > connections, so you can come back later and commit or rollback.
Rather than being a hack, 2PC sounds like it's needed for correctness; how do you handle the case of only some databases receiving the COMMIT command otherwise? -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
