Re: postgres locks... - Mailing list pgsql-general

From Tom Lane
Subject Re: postgres locks...
Date
Msg-id 9465.983723954@sss.pgh.pa.us
Whole thread Raw
In response to postgres locks...  (Jeff Davis <jdavis@dynworks.com>)
List pgsql-general
Jeff Davis <jdavis@dynworks.com> writes:
> Basically, psql would sit there trying to connect, meanwhile all the
> attempted connections wouldn't die.

More details please?  What do you mean exactly by the above statements?

> I had to "kill -9" all the
> postgres/postmaster processes.

Killing individual backends with kill -9 is NOT NOT NOT a recommended
procedure.  In theory you can get away with it but why take risks?
Use the documented shutdown procedures to give the thing some chance
of cleaning up after itself.

            regards, tom lane

pgsql-general by date:

Previous
From: brichard@cafod.org.uk (Bruce Richardson)
Date:
Subject: CREATE INDEX function limitation
Next
From: will trillich
Date:
Subject: triggers vs. 'NEW in non-rule query' -- SOLVED?