Re: initdb problems

Vladimir Tsvetkov <[email protected]> Tue, 11 Oct 2005 12:54:03 +0300
Newsgroups gmane.comp.db.postgresql.cygwin
Message-ID <[email protected]>
I've had just to change the following option for cygserver:
/etc/cygserver.conf

# kern.ipc.semmsl: Maximum no. of semaphores per semaphore id.
# Default: 60, Min: 1, Max: 1024
#kern.ipc.semmsl 60
kern.ipc.semmsl 512

And after this the initdb procedure worked without failure.
Thanx, anyway and sorry for taking from your time.

Best Regards,
Vladimir Tsvetkov

2005/10/11, Vladimir Tsvetkov <[email protected]>:
> I read the FAQ about PostgreSQL on Cygwin, but I couldn't understand
> where and when should I run:
>
> # make MAX_CONNECTIONS=3D5 check
>
> And how to increase SEMMNS to avoid the following failure:
>
> DETAIL:  Failed system call was semget(1, 17, 03600).
> HINT:  This error does *not* mean that you have run out of disk space.
>         It occurs when either the system limit for the maximum number of =
semapho
> re sets (SEMMNI), or the system wide maximum number of semaphores (SEMMNS=
), woul
> d be exceeded.  You need to raise the respective kernel parameter.  Alter=
nativel
> y, reduce PostgreSQL's consumption of semaphores by reducing its max_conn=
ections
>  parameter (currently 10).
>         The PostgreSQL documentation contains more information about conf=
iguring
>  your system for PostgreSQL.
>
> I've just upgraded my Cygwin installation. The previous installation
> of Cygwin + PostgreSQL had no problems at all.
>
> Best Regards,
> Vladimir Tsvetkov
>

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [email protected] so that your
       message can get through to the mailing list cleanly