Re: database shutdown with persistent client connections - Mailing list pgsql-general

From Tom Lane
Subject Re: database shutdown with persistent client connections
Date
Msg-id 27612.1028124591@sss.pgh.pa.us
Whole thread Raw
In response to database shutdown with persistent client connections  (g.hintermayer@inode.at (Gerhard Hintermayer))
List pgsql-general
g.hintermayer@inode.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

pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: Have been accepted as a writer for "The Register"
Next
From: Darren Ferguson
Date:
Subject: Re: Have been accepted as a writer for "The Register"