paddy carroll <paddy(dot)carroll(at)gmail(dot)com> 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
In response to
pgsql-admin by date
|Next:||From: Kevin Grittner||Date: 2012-01-20 15:38:34|
|Subject: Re: Unable to Connect to server|
|Previous:||From: Fred Parkinson||Date: 2012-01-20 14:15:37|
|Subject: Re: help with Postgres forms (Pfm)|