On Fri, Nov 20, 2009 at 7:51 AM, Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> wrote: >> Note that we don't preserve notifications when the database restarts. >> But 2PC can cope with restarts. How would that fit together? > > The notifications are written to the state file at prepare. They can be > recovered from there and written to the queue again at server start (see > twophase_rmgr.c).
Okay, but which of the backends would then leave its pointer at that place in the queue upon restart? This is also an issue for the non-restart case, what if you prepare the transaction in one backend and commit in the other? Joachim -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers