Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group