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 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 give you a similar output like "ps aux|grep
postgres:" on Linux.
If you then select on of the shown processes it will select the right
process in the main window, where you can right click and select "Kill
process" (DEL).
Hope that helps.
Regards,
Oliver
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
