Results 1 to 3 of 3
May 24, 2004, 06:37 #1
postmaster service won't start postgresql
I have postgresql (cygwin install) on W2K server. It's a test server and I didn't have battery backup. Over the weekend we had a power failure. And of course now, (since it was shut down dirty) the postmaster service won't start. Does anyone have any ideas?
May 25, 2004, 14:45 #2
This problem has hunted me since I started using Postgres on Windows. That is, assuming it's the same problem;
Check in your log files for something like this:
FATAL: pre-existing shared memory block (key 5432001, ID 0) is still in use HINT: If you're sure there are no old server processes still running, remove the shared memory block with the command "ipcrm", or just delete the file "/usr/share/postgresql/data/postmaster.pid".
There might be a work around for this, but unfortuntely I don't know what it is.
Hope this helps,
May 26, 2004, 04:13 #3
Thanks. Worked perfectly. I was able to delete it from explorer, using the postgres user I setup that has ownership of those files.
Originally Posted by sanka69