Re: [GENERAL] How to enumerate/drop user sessions in windows

2006-01-31 Thread Howard Cole
Oliver Fürst wrote: As this is a bit hard to accomplish with Windows' own task manager, get SysInternals free Process Explorer from here http://www.sysinternals.com/Utilities/ProcessExplorer.html and after starting it, use Find -> Find Handle (CTRL + F) and search for "postgres:". This will g

Re: [GENERAL] How to enumerate/drop user sessions in windows

2006-01-31 Thread Oliver Fürst
Hi, On 31.01.2006 10:33, Howard Cole wrote: Now when the Database server is running on a linux server, I can run ps and pick the sessions that I want to kill. However how can I do this on windows? Is there a psql command to kill sessions? As this is a bit hard to accomplish with Windows' own

[GENERAL] How to enumerate/drop user sessions in windows

2006-01-31 Thread Howard Cole
Hi, When trying to drop a database using psql connected to a windows server running postgresql 8.0.3, I get the error message "Database X is being accessed by other users." Now when the Database server is running on a linux server, I can run ps and pick the sessions that I want to kill. Howe