X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B304F53FB6 for ; Tue, 26 Apr 2005 08:25:10 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60381-02 for ; Tue, 26 Apr 2005 11:25:04 +0000 (GMT) Received: from main.eurocom.od.ua (Main.EuroCom.Od.UA [212.15.128.6]) by svr1.postgresql.org (Postfix) with ESMTP id C6523538C9 for ; Tue, 26 Apr 2005 08:24:59 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by main.eurocom.od.ua (Postfix) with ESMTP id 6B76A1C99CC for ; Tue, 26 Apr 2005 14:24:59 +0300 (EEST) Received: from main.eurocom.od.ua ([127.0.0.1]) by localhost (main [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25418-03 for ; Tue, 26 Apr 2005 14:24:58 +0300 (EEST) Received: from [212.15.128.37] (bm0.eurocom.od.ua [212.15.128.14]) by main.eurocom.od.ua (Postfix) with ESMTP id B027D1C9997 for ; Tue, 26 Apr 2005 14:24:58 +0300 (EEST) Message-ID: <426E250A.4090707@eurocom.od.ua> Date: Tue, 26 Apr 2005 14:24:58 +0300 From: Alexander Rusinov User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7.6) Gecko/20050404 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: PostgreSQL in FreeBSD jails Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at eurocom.od.ua X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.374 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200504/367 X-Sequence-Number: 17380 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