Re: PostgreSQL hanging on new connections? - Mailing list pgsql-general

From Tom Lane
Subject Re: PostgreSQL hanging on new connections?
Date
Msg-id 939.1291054980@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL hanging on new connections?  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: PostgreSQL hanging on new connections?
Re: PostgreSQL hanging on new connections?
Re: PostgreSQL hanging on new connections?
List pgsql-general
hubert depesz lubaczewski <depesz@depesz.com> 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?

            regards, tom lane

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: PostgreSQL hanging on new connections?
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: PostgreSQL hanging on new connections?