| From: | Howard Cole <howardnews(at)selestial(dot)com> |
|---|---|
| To: | 'PgSql General' <pgsql-general(at)postgresql(dot)org> |
| Subject: | Killing a session on windows |
| Date: | 2007-11-29 10:54:41 |
| Message-ID: | 474E9A71.3090903@selestial.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have a database I want to drop on a windows server. Unfortunately I
cannot restart postgres because it is running several live database.
To kill the offending session, I tried select * from pg_stat_activity to
find the PID of the session, and then tried to kill it with command line:
taskkill /f /pid 1234
This appeared to kill the session, but postgres still thinks the session
is live with the same process id.
Using the SysInternals process explorer - there doesn't appear to be a
process with the given ID.
How can I get postgres to drop this session?
Thanks
Howard Cole
www.selestial.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2007-11-29 10:55:20 | Re: Recheck condition |
| Previous Message | Cyril VELTER | 2007-11-29 10:53:20 | [Re] Re: [Re] Re: [Re] Re: [Re] Re: Unknown winsock error 10061while dumping a big database |