Skip site navigation (1) Skip section navigation (2)


From: Aleksander Wala <awala(at)email(dot)pl>
To: pgsql-ports(at)postgresql(dot)org
Subject: question?
Date: 2002-04-25 18:59:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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


Aleksander Wala

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: No space 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

Next:From: Tom LaneDate: 2002-05-03 02:56:50
Subject: Solaris + locale bug identified
Previous:From: Herve CADROYDate: 2002-04-25 07:34:04
Subject: POSTGRES 7.2 or 7.2.1 on HPUX11.1i

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group