Thread: Forcing Disconnection

Forcing Disconnection

From
Stephane Schildknecht
Date:
Hi,

    Is it possible to force people disconnect before shutting down the
postmaster ?
I don't have time enough to wait 'til eveybody leaves the connection.

Thanks

S@S
--
 _Stéphane SCHILDKNECHT___________________________________
| AurorA-SAS 69-71, Av. Pierre Grenier 92100 BOULOGNE     |
| Tel : 01.58.17.03.20 Fax : 01.58.17.03.21               |
| mailto:sschildknecht@aurora-linux.com - ICQ : 142504394 |
| "Free Markets have taught that innovation is best when  |
|  ideas flow freely." Adam Smith                         |
|_________________________________________________________|


Re: Forcing Disconnection

From
Bruce Momjian
Date:
Stephane Schildknecht wrote:
> Hi,
>
>     Is it possible to force people disconnect before shutting down the
> postmaster ?
> I don't have time enough to wait 'til eveybody leaves the connection.

Yes, there is a pg_ctl flag to force them all to exit.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: Forcing Disconnection

From
"Chad R. Larson"
Date:
At 09:17 AM 7/11/02 , Stephane Schildknecht wrote:
>Is it possible to force people disconnect before shutting down the
>postmaster ?
>I don't have time enough to wait 'til eveybody leaves the connection.

Check the fast/smart/immediate options to "pg_ctl stop" and "pg_ctl
restart" commands.


         -crl
--
Chad R. Larson (CRL22)    chad@eldocomp.com
   Eldorado Computing, Inc.   602-604-3100
      5353 North 16th Street, Suite 400
        Phoenix, Arizona   85016-3228