Re: 8.4.4 locked after power failure

2011/9/12 Merlin Moncure <mmoncure@gmail.com>:
>
> It seems odd that you could not create a temp sequence but you were
> able to reindex the entire database.  did you confirm you were
> blocking on a non-granted lock?


I could revacuum/reindex all stuff, only if I had to do the system
catalogues first. That seemed a bit suspicious.

Also, I had to stop all other connections - because any other locked
transaction would prevent it from going on.
Oh, the last thing - pg_cancel_backend() couldn't kill the locked
backend. I had to restart the whole postgresql using -m immediate.

Odd stuff indeed, as I was hoping postgresql will clean things like
locks on recovery from crash. Never happened to me with 8.3

--
GJ