Обсуждение: postmaster crashes on start-up
I just successfully installed postgres-ql on my Win-2K PC, with the following set-up: Windows-2000 cygwin - 1.3.22-1 postgresql - 7.3.3-1 cygipc - 1.14-1 cygipc runs as an automatic service. But every time I attempt to start the postmaster (as a service or) manually, it fails to run :-( postmaster -i -D /usr/share/postgresql/data & I get the following message: IpcSemaphoreInitialize: semctl(id=2, 0, SETVAL, 0) failed: Invalid argument LOG: startup process (pid 2472) exited with exit code 1 LOG: aborting startup due to startup process failure What am I doing wrong :-( ?? (Yes this is a repeat email, no one answered the first) Shmuel Kahn
It could be some kind of permissions problem.
Are you running the ipc-daemon as the same user as postgresql?
Did you install Just for me as a different user?
Maybe try cleaning out all the ipc file for /tmp.
hth,
- Stuart
P.S. Sorry for the format mangling the disclaimer adder forces on me :(
> -----Original Message-----
> From: Shmuel A. Kahn [mailto:Shmuel@Kam-motion.com]
> Sent: 19 June 2003 10:26
> To: pgsql-cygwin@postgresql.org
> Subject: [CYGWIN] postmaster crashes on start-up
>
>
> I just successfully installed postgres-ql on my Win-2K PC,
> with the following set-up:
>
> Windows-2000
> cygwin - 1.3.22-1
> postgresql - 7.3.3-1
> cygipc - 1.14-1
>
> cygipc runs as an automatic service. But every time I attempt
> to start the postmaster
> (as a service or) manually, it fails to run :-(
>
> postmaster -i -D /usr/share/postgresql/data &
>
> I get the following message:
> IpcSemaphoreInitialize: semctl(id=2, 0, SETVAL, 0) failed: Invalid
> argument
> LOG: startup process (pid 2472) exited with exit code 1
> LOG: aborting startup due to startup process failure
>
> What am I doing wrong :-( ??
> (Yes this is a repeat email, no one answered the first)
>
> Shmuel Kahn
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
DISCLAIMER:The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you.
Have you tried to delete IPC-related files located within /tmp before you started the "Cygwin IPC Daemon" ? Regards, Joachim >Title: RE: [CYGWIN] postmaster crashes on start-up >It could be some kind of permissions problem. >Are you running the ipc-daemon as the same user as postgresql? >Did you install Just for me as a different user? >Maybe try cleaning out all the ipc file for /tmp. >hth, >- Stuart >P.S. Sorry for the format mangling the disclaimer adder forces on me :( >> -----Original Message----- >> From: Shmuel A. Kahn [mailto:Shmuel@Kam-motion.com <mailto:Shmuel@Kam-motion.com> ] >> Sent: 19 June 2003 10:26 >> To: pgsql-cygwin@postgresql.org >> Subject: [CYGWIN] postmaster crashes on start-up >> >> >> I just successfully installed postgres-ql on my Win-2K PC, >> with the following set-up: >> >> Windows-2000 >> cygwin - 1.3.22-1 >> postgresql - 7.3.3-1 >> cygipc - 1.14-1 >> >> cygipc runs as an automatic service. But every time I attempt >> to start the postmaster >> (as a service or) manually, it fails to run :-( >> >> postmaster -i -D /usr/share/postgresql/data & >> >> I get the following message: >> IpcSemaphoreInitialize: semctl(id=2, 0, SETVAL, 0) failed: Invalid >> argument >> LOG: startup process (pid 2472) exited with exit code 1 >> LOG: aborting startup due to startup process failure >> >> What am I doing wrong :-( ?? >> (Yes this is a repeat email, no one answered the first) >> >> Shmuel Kahn >> >> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 5: Have you checked our extensive FAQ? >> >> http://www.postgresql.org/docs/faqs/FAQ.html <http://www.postgresql.org/docs/faqs/FAQ.html> >> >DISCLAIMER:The information in this message is confidential and may be legally privileged. It is intended solely for theaddressee. >Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure,copying, or distribution >of the message, or any action or omission taken by you in reliance on it, is prohibitedand may be unlawful. Please immediately >contact the sender if you have received this message in error. Thank you.