| From: | David Lizano <david(dot)lizano(at)izanet(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | RE: Sorry, too many clients already |
| Date: | 2001-03-26 18:06:16 |
| Message-ID: | 4.3.2.7.0.20010326195629.00c1c930@192.168.1.1 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
At 19.42 26/3/01 +0200, you wrote:
>Mahesh Guleria writes:
>
> > Use these commands :
> >
> > ps -ef|grep post
> > kill -9 [process id]
>
>Don't do that, it might destroy your database. SIGTERM should be used to
>kill individual backends.
>
>--
>Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/
>
You can do it like this:
killall -TERM postmaster
or
kill -TERM `pidof postmaster`
The SIGTERM signal can be trapped by a process and when is invoked the
process can close all the opened resources like files and pipes.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
David Lizano - Director área técnica
correo-e: david(dot)lizano(at)izanet(dot)com
I Z A N E T - Servicios integrales de internet.
web: http://www.izanet.com/
Dirección: C/ Checa, 57-59, 3º D - 50.007 Zaragoza (España)
Teléfono: +34 976 25 80 23 Fax: +34 976 25 80 24
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-03-26 18:19:00 | Re: Sorry, too many clients already |
| Previous Message | Björn Lundin | 2001-03-26 18:00:52 | Re: psql doesn't recognize some keys |