RE: Sorry, too many clients already

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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

In response to

Browse pgsql-admin by date

  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