Killing a session on windows

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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