pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alexander Rusinov <boot@eurocom.od.ua>
To: pgsql-admin@postgresql.org
Subject: PostgreSQL in FreeBSD jails
Date: Tue, 26 Apr 2005 14:24:58 +0300
Message-ID: <426E250A.4090707@eurocom.od.ua> (raw)

Hi,

I need to run a number of PostgreSQL servers in different FreeBSD jails. 
I managed to run a first instance of PostgreSQL server in a jail, but 
after I launch a new server in another jail the first one starts to 
return an error messages like the following:

semctl(1507328, 4, SETVAL, 0) failed: Invalid argument

The problem in general is: only one instance of PostgreSQL server 
normally processes clients' connections, all of the others return semctl 
errors.

The system is FreeBSD 5.4-PRERELEASE. SEM and SHM sysctl setting are:

# sysctl -a | grep shm
kern.ipc.shmmax: 100000000
kern.ipc.shmmin: 1
kern.ipc.shmmni: 192
kern.ipc.shmseg: 128
kern.ipc.shmall: 32768
kern.ipc.shm_use_phys: 0
kern.ipc.shm_allow_removed: 0

# sysctl -a | grep sem
kern.ipc.semmap: 256
kern.ipc.semmni: 256
kern.ipc.semmns: 512
kern.ipc.semmnu: 256
kern.ipc.semmsl: 60
kern.ipc.semopm: 100
kern.ipc.semume: 10
kern.ipc.semusz: 92
kern.ipc.semvmx: 32767
kern.ipc.semaem: 16384

Trying to solve the problem I've set the following in postgresql.conf files:
max_connections = 5
shared_buffers = 100

Please help! What am I doing wrong?

-- 
Alexander Rusinov




view thread (2+ messages)  latest in thread

Message-ID: <426E250A.4090707@eurocom.od.ua>
Permalink:  ../426E250A.4090707@eurocom.od.ua/
Also on:    postgresql.org/message-id/426E250A.4090707@eurocom.od.ua

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: boot@eurocom.od.ua
  Subject: Re: PostgreSQL in FreeBSD jails
  In-Reply-To: <426E250A.4090707@eurocom.od.ua>
  References: <426E250A.4090707@eurocom.od.ua>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox