2011/9/12 Grzegorz Jaśkiewicz <gryz...@gmail.com>: > So here's the thing. I got a message from one of the developers, that > running 'create temporary sequence xyz;' hangs on the database. > That seemed suspicious. I tried running any ddl command, and that hang. > No other connections to the database. > > It turned out that it had a power failure earlier in the morning. That > seems ok, but in the past postgresql will always recover fine (at > least 8.3.x). > This time I had to reindex, and vacuum all user and system catalogues > to get system back in order. > > Any ideas ? Is that something new, is it fixed in any newer releases ? > > > Unfortunately it had to be done rather quick - so I couldn't salvage any data.
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? merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general