I am having a semaphore issue when running initdb. The FAQ and PAG
didn't help.

System data:
AMD64
1G RAM
80G HD
VIA Chipset
Linux 2.6.1-gentoo (contains special AMD64 patches). Contains IPC in
kernel.
postmaster (PostgreSQL) 7.3.5

I am also asking in the gentoo list to see if it is the architecture or
kernel. Nothing would indicate that so far. Postgresql is labeled as
stable for this architecture by emerge.

Output of initdb:

creating template1 database in /usr/local/lib/postgresql/data/base/1...
IpcSemaphoreCreate: semget(key=129, num=17, 03600) failed: No space left
on device
Blah blah you are not out of disk space - see PAG...etc...you're
buggered.

--debug adds this nice tidbid:
DEBUG: invoking IpcMemoryCreate(size=17596416)

and THEN it blows up with the same as above :P - hmmm...is that size right?!

Output of df -h:
Filesystem Size Used Avail Use% Mounted on
/dev/hda2 487M 203M 285M 42% /
/dev/hda5 38G 555M 37G 2% /home
/dev/hda6 965M 65M 901M 7% /var
/dev/hda9 9.4G 4.0G 5.5G 42% /usr
/dev/hda7 4.7G 52M 4.7G 2% /usr/local
none 501M 0 501M 0% /dev/shm

I don't see how it can be a space issue.

Free:
total used free shared buffers cached
Mem: 1024536 857692 166844 0 80276 248784
-/+ buffers/cache: 528632 495904
Swap: 136544 4932 131612

I don't think it is memory either...

Dmesg output is about kernel modules for sound and ethernet and are
three days old. Nothing interesting.

Output of ipcs:
nroberts@bart done $ ipcs

------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 32768 nroberts 600 393216 2 dest
0x00000000 65537 nroberts 600 393216 2 dest
0x00000000 98306 nroberts 600 393216 2 dest
0x00000000 131075 nroberts 600 393216 2 dest
0x00000000 163844 nroberts 600 393216 2 dest
0x00000000 196613 nroberts 600 393216 2 dest
0x00000000 229382 nroberts 600 393216 2 dest
0x00000000 262151 nroberts 600 393216 2 dest
0x00000000 294920 nroberts 600 393216 2 dest
0x00000000 327689 nroberts 600 393216 2 dest
0x00000000 360458 nroberts 600 393216 2 dest
0x00000000 393227 nroberts 777 393216 2 dest
0x00000000 1015820 nroberts 600 393216 2 dest
0x00000000 1048589 nroberts 600 393216 2 dest
0x00000000 1081358 nroberts 600 12288 2 dest
0x00000000 1114127 nroberts 600 12288 2 dest
0x00000000 1146896 nroberts 600 393216 2 dest
0x00000000 1179665 nroberts 600 393216 2 dest
0x00000000 1212434 nroberts 777 393216 2 dest
0x00000000 6750227 root 644 110592 2 dest
0x00000000 6782996 root 644 110592 2 dest
0x00000000 6357013 root 644 122880 2 dest
0x00000000 6389782 root 644 110592 2 dest
0x00000000 6422551 root 644 110592 2 dest
0x00000000 6455320 root 644 110592 2 dest
0x00000000 6488089 root 644 110592 2 dest
0x00000000 6520858 root 644 106496 2 dest
0x00000000 7438363 root 644 110592 2 dest
0x00000000 7471132 root 644 122880 2 dest
0x00000000 7503901 root 644 122880 2 dest
0x00000000 7536670 root 644 110592 2 dest
0x00000000 7897119 root 644 122880 2 dest
0x00000000 7929888 root 644 122880 2 dest
0x00000000 7962657 root 644 110592 2 dest
0x00000000 7995426 root 644 110592 2 dest
0x00000000 8028195 root 644 110592 2 dest
0x00000000 8060964 root 644 110592 2 dest
0x00000000 8093733 root 644 122880 2 dest
0x00000000 8126502 root 644 110592 2 dest
0x00000000 8159271 root 644 122880 3 dest
0x00000000 8192040 root 644 110592 2 dest
0x00000000 8224809 root 644 110592 2 dest
0x00000000 8257578 root 644 110592 2 dest
0x00000000 8290347 root 644 122880 2 dest
0x00000000 8323116 root 644 122880 2 dest

------ Semaphore Arrays --------
key semid owner perms nsems

------ Message Queues --------
key msqid owner perms used-bytes messages

/proc/sys/kernel/shm*:
134217728000
134217728000
1073741824

Yes, those first values are rediqulous but I tried to up the limit
suggested by the FAQ.

Any ideas?

Thanks.
--
"I'm a war president. I make decisions here in the Oval Office
in foreign policy matters with war on my mind." - Bush

Hi,
i've had the same problem with similiar configuration. Solved this by
compiling 7.4.2 tarball manually. I still wonder if it's possible
to emerge working postgres installation on AMD64/Gentoo.
Does anyone know ?

--
ArtB


Noah Roberts wrote: