From: Mario Soto Cordones <msotocl@gmail.com>
To: Alexander Rusinov <boot@eurocom.od.ua>
Cc: pgsql-admin@postgresql.org
Subject: Re: PostgreSQL in FreeBSD jails
Date: Tue, 26 Apr 2005 14:25:13 -0400
Message-ID: <e9b17cde05042611254c253698@mail.gmail.com> (raw)
In-Reply-To: <426E250A.4090707@eurocom.od.ua>
References: <426E250A.4090707@eurocom.od.ua>
2005/4/26, Alexander Rusinov <boot@eurocom.od.ua>:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
cordialmente,
Ing. Mario Soto Cordones
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: msotocl@gmail.com, boot@eurocom.od.ua
Subject: Re: PostgreSQL in FreeBSD jails
In-Reply-To: <e9b17cde05042611254c253698@mail.gmail.com>
References: <426E250A.4090707@eurocom.od.ua> <e9b17cde05042611254c253698@mail.gmail.com>
* 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