Clodoaldo escribió:
> Postgresql was restarted twice, but yes, it is as if the crash left
> some kind of permanent lock somewhere.
A prepared transaction perhaps? SELECT * FROM pg_prepared_xacts;
A quick look into pg_locks should tell you if it's blocking.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support