Thread: Killing only one postmaster

Killing only one postmaster

From
stewarrb@yahoo.com (Bo Stewart)
Date:
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

Re: Killing only one postmaster

From
Date:

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/


Re: Killing only one postmaster

From
Michiel Lange
Date:
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)


Re: Killing only one postmaster

From
"H. Etzel"
Date:
I think this does not work!!
I have had the same Problem, but after I killed on connection all other
connection were reseted!!

codeWarrior wrote:
> Get the process id of your postmaster's...
>
> # ps ax | grep postmaster
> # kill (pidnumber of the seletcted postmaster)
>
>
>
> "Bo Stewart" <stewarrb@yahoo.com> wrote in message
> news:9a41d107.0304110640.374e1dd@posting.google.com...
>> 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


Re: Killing only one postmaster

From
Tom Lane
Date:
"H. Etzel" <hetzel.devel@web.de> writes:
> I think this does not work!!
> I have had the same Problem, but after I killed on connection all other
> connection were reseted!!

You're not supposed to do it like that --- use "kill -INT pid" not
a plain kill.

            regards, tom lane


Re: Killing only one postmaster

From
"codeWarrior"
Date:
Get the process id of your postmaster's...

# ps ax | grep postmaster
# kill (pidnumber of the seletcted postmaster)



"Bo Stewart" <stewarrb@yahoo.com> wrote in message
news:9a41d107.0304110640.374e1dd@posting.google.com...
> 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



Re: Killing only one postmaster

From
Michiel Lange
Date:
It is even easier:
pg_ctl -D <directory> stop

and if you want to do it the hardcore way:
kill -TERM `head -n 1 <data dir>`

The problem with the ps command is probably that it may be hard to find out
which postmaster you are about to kill...
hence the directory approach...

Michiel
At 17:20 11-4-2003 -0700, codeWarrior wrote:
>Get the process id of your postmaster's...
>
># ps ax | grep postmaster
># kill (pidnumber of the seletcted postmaster)
>
>
>
>"Bo Stewart" <stewarrb@yahoo.com> wrote in message
>news:9a41d107.0304110640.374e1dd@posting.google.com...
> > 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 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly