Re: server won't shutdown

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ed L(dot)" <pgadmin(at)bluepolka(dot)net>
Cc: Laurette Cisneros <laurette(at)nextbus(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: server won't shutdown
Date: 2003-02-18 00:09:43
Message-ID: 16389.1045526983@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Ed L." <pgadmin(at)bluepolka(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ed L. 2003-02-18 00:24:20 Re: server won't shutdown
Previous Message Tom Lane 2003-02-17 23:58:37 Re: server won't shutdown