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 A04345296E for ; Tue, 26 Apr 2005 15:25:18 -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 76563-05 for ; Tue, 26 Apr 2005 18:25:14 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.203]) by svr1.postgresql.org (Postfix) with ESMTP id 732D253505 for ; Tue, 26 Apr 2005 15:25:12 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 34so37512nzf for ; Tue, 26 Apr 2005 11:25:13 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=RE+jsPwvMvgb9lZyRI/vrB+WmZZqGpmSRUWEtP8/EF+jJLpGSaSl3zu2t4my8W/8b921+0l0gsKxexb6Nc17BjYqBKsxpIgur17Dd5DMNoHCDAAELOv2+EsdJmDaxqdnsjAearb+7rjpP/3nTPionU8ypVVJCiBQMDCZoxjLLbo= Received: by 10.36.8.17 with SMTP id 17mr856nzh; Tue, 26 Apr 2005 11:25:13 -0700 (PDT) Received: by 10.36.57.11 with HTTP; Tue, 26 Apr 2005 11:25:13 -0700 (PDT) Message-ID: Date: Tue, 26 Apr 2005 14:25:13 -0400 From: Mario Soto Cordones Reply-To: Mario Soto Cordones To: Alexander Rusinov Subject: Re: PostgreSQL in FreeBSD jails Cc: pgsql-admin@postgresql.org In-Reply-To: <426E250A.4090707@eurocom.od.ua> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <426E250A.4090707@eurocom.od.ua> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.511 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/369 X-Sequence-Number: 17382 2005/4/26, Alexander Rusinov : > Hi, >=20 > 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: >=20 > semctl(1507328, 4, SETVAL, 0) failed: Invalid argument >=20 > The problem in general is: only one instance of PostgreSQL server > normally processes clients' connections, all of the others return semctl > errors. >=20 > The system is FreeBSD 5.4-PRERELEASE. SEM and SHM sysctl setting are: >=20 > # 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 >=20 > # 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 >=20 > Trying to solve the problem I've set the following in postgresql.conf fil= es: > max_connections =3D 5 > shared_buffers =3D 100 >=20 > Please help! What am I doing wrong? >=20 > -- > Alexander Rusinov >=20 > ---------------------------(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 >=20 --=20 cordialmente, Ing. Mario Soto Cordones