Re: initdb problems

OOOps, I meant the semmns option.

I've had just to change the following option for cygserver:
/etc/cygserver.conf

# kern.ipc.semmns: Maximum no. of semaphores hold concurrently.
# Default: 60, Min: 1, Max: 1024
#kern.ipc..semmns 60
kern.ipc..semmns 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 o=
f semapho
> > re sets (SEMMNI), or the system wide maximum number of semaphores (SEMM=
NS), woul
> > d be exceeded.  You need to raise the respective kernel parameter.  Alt=
ernativel
> > y, reduce PostgreSQL's consumption of semaphores by reducing its max_co=
nnections
> >  parameter (currently 10).
> >         The PostgreSQL documentation contains more information about co=
nfiguring
> >  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 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq