question? - Mailing list pgsql-ports

From Aleksander Wala
Subject question?
Date
Msg-id 1103668196.20020425205957@email.pl
Whole thread Raw
List pgsql-ports
I tried to upgrade on FreeBSD 4.5
from 7.1.x to 7.2.1
everything is fine untill... initdb
HOWTO reduce PostgreSQL's consumptions on semaphores
i work remotely and have no posibility to change kernel settings

THANKS FOR HELP

Aleksander Wala
POLAND

creating directory /usr/local/pgsql/data... ok
creating directory /usr/local/pgsql/data/base... ok
creating directory /usr/local/pgsql/data/global... ok
creating directory /usr/local/pgsql/data/pg_xlog... ok
creating directory /usr/local/pgsql/data/pg_clog... ok
creating template1 database in /usr/local/pgsql/data/base/1... IpcSemaphoreCreate: semget(key=2, num=17, 03600) failed:
Nospace left on device 

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
semaphore sets (SEMMNI), or the system wide maximum number of
semaphores (SEMMNS), would be exceeded.  You need to raise the
respective kernel parameter.  Alternatively, reduce PostgreSQL's
consumption of semaphores by reducing its max_connections parameter
(currently 32).

The PostgreSQL Administrator's Guide contains more information about
configuring your system for PostgreSQL.


initdb failed.
Removing /usr/local/pgsql/data.



pgsql-ports by date:

Previous
From: "Herve CADROY"
Date:
Subject: POSTGRES 7.2 or 7.2.1 on HPUX11.1i
Next
From: Tom Lane
Date:
Subject: Solaris + locale bug identified