Postgres Pro
Downloads
Home   >   mailing lists

Re: server won't shutdown - Mailing list pgsql-admin

From Tom Lane
Subject Re: server won't shutdown
Date
Msg-id 16389.1045526983@sss.pgh.pa.us
Whole thread Raw
In response to Re: server won't shutdown  (Laurette Cisneros <laurette@nextbus.com>)
Responses Re: server won't shutdown  ("Ed L." <pggeneral@bluepolka.net>)
List pgsql-admin
Tree view 
"Ed L." <pgadmin@bluepolka.net> writes:
> I've been seeing the same problem intermittently over the past 2 years
> among ~30 production clusters.

Hm, I suddenly have a theory.  Do you guys use LISTEN/NOTIFY in the
databases that are exhibiting the problem?  Is it possible that the
backends that aren't cooperating have not done anything since they
last received a NOTIFY?  (That would imply that the connected frontend
didn't issue any SQL commands in response to the notification.)

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: server won't shutdown
Next
From: "Ed L."
Date:
Subject: Re: please help--database just locks up.