Re: database shutdown with persistent client connections

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: g(dot)hintermayer(at)inode(dot)at (Gerhard Hintermayer)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: database shutdown with persistent client connections
Date: 2002-07-31 14:09:51
Message-ID: 27612.1028124591@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

g(dot)hintermayer(at)inode(dot)at (Gerhard Hintermayer) writes:
> Is there a notification sen't out in either smart or fast shutdown
> mode ?

Sure: the backend sends an error message
FATAL: This connection has been terminated by the administrator.
before closing the connection.

The problem you're describing is that the client-side code isn't looking
for any communication from the server except when it's involved in a SQL
command. I'm not sure what you can do about that except restructure the
client.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Darren Ferguson 2002-07-31 14:10:29 Re: Have been accepted as a writer for "The Register"
Previous Message Justin Clift 2002-07-31 13:58:26 Re: Have been accepted as a writer for "The Register"