Re: Killing only one postmaster - Mailing list pgsql-admin

From Michiel Lange
Subject Re: Killing only one postmaster
Date
Msg-id 5.1.0.14.0.20030411231757.00b5c700@192.168.1.3
Whole thread Raw
In response to Killing only one postmaster  (stewarrb@yahoo.com (Bo Stewart))
List pgsql-admin
There can also be multiple backends... look for the PID you want to kill
(SIGHUP or SIGTERM) in your $PGDATA/postmaster.pid file

Michiel
At 23:57 11-4-2003 +0530, mallah@trade-india.com wrote:


>I think there is only one postmaster and multiple backends.
>
>To cancel the query being executed by a particular backend pid
>use
>
>kill -INT <pid_of_the_backend>
>its equivalent to pressing ^C in psql for that query.
>
>regds
>mallah.
>
> > How do I stop only one postmaster and not have the entire server
> > restart?  Is this possible.  I have had several situations where I have
> a function not
> > performing as I expect and need to kill just the backend process.
> >
> >
> > Thanks,
> > Bo Stewart
> >
> >
> > ---------------------------(end of
> broadcast)--------------------------- TIP 1: subscribe and
> > unsubscribe commands go to majordomo@postgresql.org
>
>
>
>-----------------------------------------
>Get your free web based email at trade-india.com.
>    "India's Leading B2B eMarketplace.!"
>http://www.trade-india.com/
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


pgsql-admin by date:

Previous
From: Tim Ellis
Date:
Subject: Re: Netscape Suitespot HELP :-/
Next
From: P G
Date:
Subject: Has anyone seen this error? I cannot log into my database.