X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9233411F6202; Wed, 5 Apr 2006 05:22:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 29536-02; Wed, 5 Apr 2006 05:22:20 -0300 (ADT) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 8092211F6009; Wed, 5 Apr 2006 05:22:19 -0300 (ADT) Received: from mx1.sonologic.nl (mx1.sonologic.nl [82.94.245.21]) by svr4.postgresql.org (Postfix) with ESMTP id B5FE55AF89F; Wed, 5 Apr 2006 08:22:19 +0000 (GMT) Received: from [10.1.5.2] (sonologic.xs4all.nl [80.127.84.188]) (authenticated bits=0) by mx1.sonologic.nl (8.13.6/8.13.6) with ESMTP id k358MCVE042996; Wed, 5 Apr 2006 08:22:15 GMT Message-ID: <44337F15.20709@metro.cx> Date: Wed, 05 Apr 2006 10:25:57 +0200 From: Koen Martens Organization: Sonologic User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.6) Gecko/20050317 Thunderbird/1.0.2 Mnenhy/0.7.2.0 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Marc G. Fournier" Cc: pgsql-admin@postgresql.org Subject: Re: semctl(): Invalid argument References: <20060402143109.T947@ganymede.hub.org> <20060402163341.P947@ganymede.hub.org> In-Reply-To: <20060402163341.P947@ganymede.hub.org> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Helo-Milter-Authen: gmc@sonologic.nl, pgsql@metro.cx, mx1 Received-SPF: pass (mx1.sonologic.nl: 80.127.84.188 is authenticated by a trusted mechanism) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200604/52 X-Sequence-Number: 21221 FWIW, i've been running two postmasters on the same port on a FreeBSD 6.0-RELENG server, one in the host and one in a jail (this is on a devel server). I don't like running postgresql in a jail anyway, because it involves enabling sysv IPC inside jails, which sort of defeats the entire purpose of having a jail.. Gr, Koen Marc G. Fournier wrote: > > It looks like moving to FreeBSD 6.x for some of our servers is biting me > in the butt ... they "broke" something with semaphores that used to work > with 4.x, so that you can't run two postmasters on port 5432 within two > seperate jails ... :( > > On Sun, 2 Apr 2006, Marc G. Fournier wrote: > >> >> What would cause the following? >> >> # psql -U pgsql -l >> psql: FATAL: semctl(327686, 3, SETVAL, 0) failed: Invalid argument >> >> The server is FreeBSD 6.1-PRERELEASE ... there are two jails running >> on it ... both jails are running PostgreSQL 7.4 ... I have the kernel >> built with enough semaphores: >> >> options SYSVSHM >> options SHMMAXPGS=199608 >> options SHMMAX=(SHMMAXPGS*PAGE_SIZE+1) >> >> options SYSVSEM >> options SEMMNI=4096 >> options SEMMNS=8192 >> >> options SYSVMSG # SYSV-style message queues >> >> And am definitely not using that many: >> >> (from ipcs -a): >> ID KEY MODE OWNER GROUP CREATOR >> CGROUP NSEMS OTIME CTIME s 393216 5432001 >> --rw------- 70 70 70 70 17 13:46:07 13:46:07 >> s 393217 5432002 --rw------- 70 70 >> 70 70 17 13:46:07 13:46:07 >> s 393218 5432003 --rw------- 70 70 >> 70 70 17 13:46:07 13:46:07 >> s 393219 5432004 --rw------- 70 70 >> 70 70 17 13:46:07 13:46:07 >> s 393220 5432005 --rw------- 70 70 >> 70 70 17 13:46:07 13:46:07 >> s 393221 5432006 --rw------- 70 70 >> 70 70 17 13:46:07 13:46:07 >> s 393222 5432007 --rw------- 70 70 >> 70 70 17 13:46:07 13:46:07 >> >> So figure there must be something else that I should be looking at ... >> >> Thanks ... >> >> ---- >> Marc G. Fournier Hub.Org Networking Services >> (http://www.hub.org) >> Email: scrappy@hub.org Yahoo!: yscrappy ICQ: >> 7615664 >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 6: explain analyze is your friend >> > > ---- > Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) > Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > > -- K.F.J. Martens, Sonologic, http://www.sonologic.nl/ Networking, hosting, embedded systems, unix, artificial intelligence. Public PGP key: http://www.metro.cx/pubkey-gmc.asc Wondering about the funny attachment your mail program can't read? Visit http://www.openpgp.org/