Thread: Postgresql-server w/NetBSD 1.6.1 on a Cobalt Qube2

A buddy of mine and I have a few of these Qube2's that we tweaked up
with alot of extra parts (and I mean tweaked). I am trying to get
Postgresql-server running on it,  it will compile everything ok,  but
when I go to initdb the database I get the error about

IpcSemaphoreCreate(key=4, num=17, 03600)  I have scanned google and
every site that was anywhere relevant but cant find an answer to get
this working,  I have recompiled the kernel with the options recommended
for large servers and still no joy.  This box has 256 megs ram so its no
slouch on that reguard.  Could anybody point me in a direction of where
to look to figure this out.  Or if a developer would like, I can give
them access to the box to see what might be able to be done to get this
working.

Wayne

Wayne Ringling writes:

> when I go to initdb the database I get the error about
>
> IpcSemaphoreCreate(key=4, num=17, 03600)  I have scanned google and
> every site that was anywhere relevant but cant find an answer to get

We need to know the full error message and the version of PostgreSQL that
you are using.

--
Peter Eisentraut   peter_e@gmx.net

> > IpcSemaphoreCreate(key=4, num=17, 03600)  I have scanned google and
> > every site that was anywhere relevant but cant find an answer to get
>
> We need to know the full error message and the version of PostgreSQL that
> you are using.

System is a NetBSD 1.6.1 from the qube2 restore cd available in the
port-cobalt section of NetBSD

PostgreSQL version is (I downloaded the ports file from NetBSD and
installed from there. make && make install && make clean)

postgresql-7.3.1.tar.gz

Here is the output from the initdb command.
---------------------------------------------------------------------------------
# ./pgsql initdb
Initializing PostgreSQL databases.
The files belonging to this database system will be owned by user
"pgsql".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/pkg/pgsql/data... ok
creating directory /usr/pkg/pgsql/data/base... ok
creating directory /usr/pkg/pgsql/data/global... ok
creating directory /usr/pkg/pgsql/data/pg_xlog... ok
creating directory /usr/pkg/pgsql/data/pg_clog... ok
creating template1 database in /usr/pkg/pgsql/data/base/1...
IpcSemaphoreCreate: semget(key=4, 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 1).

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


initdb failed.
Removing /usr/pkg/pgsql/data.
#
------------------------------------------------------------------------------------
Here is my kernel cfg after I compiled a new kernel and rebooted.

options         SYSVMSG         # System V message queues
options         SYSVSEM         # System V semaphores
options         SEMMNI=512      # number of semaphore identifiers
options         SEMMNS=1024     # number of semaphores in system
#options        SEMUME=40       # max number of undo entries per process
options         SEMMNU=512      # number of undo structures in system
options         SEMMSL=256
options         SEMOPM=256
options         SEMMAP=512
options         SYSVSHM         # System V shared memory
options         SHMMAXPGS=4096  # 1024 pages is the default
options         SHMMAX="(SHMMAXPGS*PAGE_SIZE+1)"
options         SHMMIN=2
options         SHMSEG=256

I followed these directions to recompile the kernel

http://mail-index.netbsd.org/port-cobalt/2003/09/04/0000.html

Could this be caused by not launching the script from bash?  Since the
shell on the system is csh & sh?

Thanks again for looking at this.