On Mon, Nov 29, 2010 at 01:23:00PM -0500, Tom Lane wrote: > hubert depesz lubaczewski <depesz@xxxxxxxxxx> writes: > > straced postmaster when the problem was happening, and I was opening new > > connections. strace looks like this: > > [ backend hangs on semop immediately after reading global/pg_database ] > > It looks like something had exclusive lock on the database that new > connections wanted to connect to. AFAICS the only action in 8.3 that > would do that would be a DROP DATABASE or RENAME DATABASE. What was > that other session doing? just some select. as far as I know there are no backends with such commands - drop/rename db. depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: depesz@xxxxxxxxxx / aim:depeszhdl / skype:depesz_hdl / gg:6749007 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
