Brian McNally <bmcnally@xxxxxx> writes: > Ok, I'm running with all available updates and kernel 2.6.18-308.4.1.el5 > but am still having the same problem. It's fairly clearly blocked on a lock ... have you looked into the pg_locks view to see what is holding the lock? (I'm wondering about a prepared transaction, myself. There isn't much else that could hold a lock across a server restart.) regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
