terminate PG connections - Mailing list pgsql-admin

From Isabella Ghiurea
Subject terminate PG connections
Date
Msg-id 4A4A5815.3050600@nrc-cnrc.gc.ca
Whole thread Raw
Responses Re: terminate PG connections  ("Plugge, Joe R." <JRPlugge@west.com>)
Re: terminate PG connections  (raghu ram <raghuchennuru@gmail.com>)
List pgsql-admin
Hello PG Users,
I would like to know if  there is  a "clean" way to terminate  running
and idle connections inside PG db ?
 ( I see : pg_cancel_backend (pid) will send the connections to idle
stage but not disconnecting from db , if you have  > 100  idle
connections to db  and don't want to use  the OS " kill "  )

Thank you
Isabella


--
-----------------------------------------------------------
Isabella A. Ghiurea

Isabella.Ghiurea@nrc-cnrc.gc.ca
Canadian Astronomy Data Centre | http://www1.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/
National Research Council of Canada, Herzberg Institute of Astrophysics
5071 West Saanich Road, Victoria BC V9E 2E7, Canada
Phone: 250 363-3446 fax: 250 363-0045


pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Partioning in postgres
Next
From: Emanuel Calvo Franco
Date:
Subject: Re: Optimal Flexible Architecture or Optimal Configuration Layout for Postgres