On Thu, 2009-05-28 at 14:04 +0300, Heikki Linnakangas wrote: > I've committed a patch to do the RequstXLogSwitch() before shutdown > checkpoint as discussed. It seems safe to me. (sorry for the delay, and > thanks for the reminder)
Not sure if that is a fix that will work in all cases. There is a potential timing problem with when the archiver is shutdown: that may now be fixed in 8.4, see what you think. Also if archiving is currently stalled, then files will not be transferred, even if you switch xlogs. So this is at best a partial fix to the problem and the need for a manual check of file contents remains. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers