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