question?

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: 1103668196.20020425205957@email.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

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: 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.

Browse pgsql-ports by date

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