Thread: Killing only one postmaster
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
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/
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)
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
"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
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
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