paddy carroll <paddy.carroll@xxxxxxxxx> writes: > 3) For 8.3.7 the locks persist a database shutdown and startup cycle - I have had to trash and rebuild the database in question. > 4) For 8.3.7 I have demonstrated that I can remedy the problem by stopping the database, deleting the contents of pg_twophase and pg_subtrans and restarting the database Egad. Please read about prepared transactions and how to commit them or roll them back; or else fix your applications to not use them. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin