Hi,
Since a while back PosgreSQL have started to hang making interaction with it impossible. The process still remains in the taskmanager aswell as another process with the same name (which i guess is the service trying to restart but failing).
The process that remains I cannot kill however i try, I get a message 'The operation could not be completed. Access is denied.' from taskmanager even though I'm in administrator mode. I've tried to kill the process using Process Explorer and command line taskkill but unsuccessful.
Using pg_ctl doesn't work either, it just tells me there's no process with the PID i specified (which i got from the taskmanager). No postmaster.pid file exists in the postgresql data folder and it doesn't make any difference if i try to forge one.
This problem is really getting on my nerves making me need to restart every three hours or so (postgres does work from time to time) and some pointers would really be appreciated.
I'm using an Acer Travelmate 6592 with Windows Xp Professional Service Pack 3 and PostgreSQL 8.3.
Since a while back PosgreSQL have started to hang making interaction with it impossible. The process still remains in the taskmanager aswell as another process with the same name (which i guess is the service trying to restart but failing).
The process that remains I cannot kill however i try, I get a message 'The operation could not be completed. Access is denied.' from taskmanager even though I'm in administrator mode. I've tried to kill the process using Process Explorer and command line taskkill but unsuccessful.
Using pg_ctl doesn't work either, it just tells me there's no process with the PID i specified (which i got from the taskmanager). No postmaster.pid file exists in the postgresql data folder and it doesn't make any difference if i try to forge one.
This problem is really getting on my nerves making me need to restart every three hours or so (postgres does work from time to time) and some pointers would really be appreciated.
I'm using an Acer Travelmate 6592 with Windows Xp Professional Service Pack 3 and PostgreSQL 8.3.