Forcing Disconnection

Поиск
Список
Период
Сортировка
Искать

Forcing Disconnection

От:
Stephane Schildknecht <sschildknecht@aurora-linux.com>
Дата:
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

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
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

От:
"Chad R. Larson" <clarson@eldocomp.com>
Дата:
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

FAQ