| From: | Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com> |
|---|---|
| To: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: how to terminate a process when kill fails |
| Date: | 2002-10-30 18:49:28 |
| Message-ID: | 3DC029B8.7010605@intransa.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
How about
pg_ctl stop -m smart # smart = wait for all clients to disconnect
pg_ctl stop -m fast # fast = don't bother waiting,
rollback all transactions
pg_ctl stop -m immediate # immediate = abort all server processes
See pg_ctl(1)
ohnson, Shaunn wrote:
> Running PostgreSQL 7.2.1 on RedHat Linux 7.2.
>
> I think I may have asked before, but I never got an answer
> that told me one way or another -
>
> How can I kill processes without kill -9 <pid> and
> ruining the database?
>
> I've tried restarting postgreSQL hoping that it cleans up
> a few things. I've tried to simply kill the processes that
> were running. Nothing happens; nothing dies. I don't see
> much of anything in the messages / log files.
>
> Any suggestions?
>
> -X
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-10-30 18:52:46 | Re: how to terminate a process when kill fails |
| Previous Message | Richard Huxton | 2002-10-30 18:45:30 | Re: newbie question for return date |