[BSD] PostgreSQL 7.4

[Fehér János]

Marton Kenyeres wrote:

>On Thursday 27 November 2003 23.04, FEHER Janos wrote:
>
>>Sziasztok!
>>
>>FreeBSD 4.8-ra próbálom beizzítani a 7.4-es PostgreSQL-t.
>>
>>Aszondja:
>>
>>creating template1 database in /usr/local/pgsql/data/base/1 ... FATAL: 
>>could not create semaphores: No space left on device DETAIL:  Failed system
>>call was semget(1, 17, 03600).
>>HINT:  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 10).  The PostgreSQL documentation
>>contains more information about configuring your system for PostgreSQL. 
>>child process exited with exit code 1
>
>
>Lehet, hogy hulye kerdes, de kernelben van 'options SYSVSEM' ?
>
Igen.

>sysctl kern.ipc mit mond? Es az ipcs -a ?
>
Message Queues:
T     ID     KEY        MODE       OWNER    GROUP  CREATOR   CGROUP CBYTES  QNUM QBYTES LSPID LRPID   STIME    RTIME    CTIME

Shared Memory:
T     ID     KEY        MODE       OWNER    GROUP  CREATOR   CGROUP NATTCH  SEGSZ  CPID  LPID   ATIME    DTIME    CTIME
m  65536    5432001 --rw-------    pgsql    pgsql    pgsql    pgsql      0 1466368    143    14312:29:41 22:05:41 12:29:41

Semaphores:
T     ID     KEY        MODE       OWNER    GROUP  CREATOR   CGROUP NSEMS   OTIME    CTIME
s  65536    5432001 --rw-------    pgsql    pgsql    pgsql    pgsql     17no-entry 12:29:41
s  65537    5432002 --rw-------    pgsql    pgsql    pgsql    pgsql     17no-entry 12:29:41
s  65538    5432003 --rw-------    pgsql    pgsql    pgsql    pgsql     17no-entry 12:29:41

kern.ipc.semmap: 30
kern.ipc.semmni: 10
kern.ipc.semmns: 60
kern.ipc.semmnu: 30
kern.ipc.semmsl: 60
kern.ipc.semopm: 100
kern.ipc.semume: 10
kern.ipc.semusz: 92
kern.ipc.semvmx: 65535
kern.ipc.semaem: 16384
kern.ipc.shmmax: 33554432
kern.ipc.shmmin: 1
kern.ipc.shmmni: 192
kern.ipc.shmseg: 128
kern.ipc.shmall: 8192
kern.ipc.shm_use_phys: 0

Mondhatni default értékek.

>Masik otlet: egesz veletlenul nem jailben akarod futtatni a postgrest? Mert 
>akkor kell neki egy sysctl jail.sysvipc_allowed=1 is.
>
Nem, egyelőre.

Üdv,
--
 _____  _  ____  ___  _____  ___  ___       _____  .
| | | :|_||  | ||   :| | | ||   ||   ||   ||   __: | Fehér János
| | | || ||    ||   || | | |:   :| --:|---':__   | | -----------------
| ___ ||_||_|__|:___|:_____:|___||   ||   ||_____| | ` vezető fejlesztő
info at mindworks.hu - www.mindworks.hu -  networking : ` ügyvezető