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: | Raw Message | Whole Thread | 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 |