From: | Max Kanat-Alexander <maxka(at)myrealbox(dot)com> |
---|---|
To: | PostgreSQL Cygwin <pgsql-cygwin(at)postgresql(dot)org> |
Subject: | IpcSemaphoneInitialize ... Invalid Argument (Solved) |
Date: | 2003-08-09 21:50:39 |
Message-ID: | 5.2.1.1.2.20030809144424.02948ea0@pop3.myrealbox.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
I noticed back in the archives around June that somebody was having a
problem which I encountered running 7.3.4 on Cygwin, Win2K. I fixed it, so
I thought I'd post the solution to the list, since I didn't notice it
having been posted. Forgive me if it's already been solved before. :-)
The postmaster service fails to start, and the error message in
/var/log/postmaster.log is:
IpcSemaphoreInitialize: semctl(id=2, 0, SETVAL, 0) failed: Invalid argument
LOG: startup process (pid 2532) exited with exit code 1
LOG: aborting startup due to startup process failure
What apparently happened is that the Win2K SCM had the wrong password for
the "./postgres" user.
More specifically, the incantation that I went through which seemed to fix it:
1) Changed postmaster to log on as Local System, and attempt to start it.
(Failed to start.)
2) Change postmaster back to logging on as "postgres", and re-type in the
password for "postgres" in the provided box.
3) Start postmaster using "net start postmaster" in Cygwin.
-Max
From | Date | Subject | |
---|---|---|---|
Next Message | Xinyu Hua | 2003-08-09 22:57:42 | less: not found |
Previous Message | Roger Ackroyd | 2003-08-09 20:44:03 | Re: [GENERAL] FATAL: The database system is in recovery mode |