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. -- GJ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
