From: | Koen Martens <pgsql(at)metro(dot)cx> |
---|---|
To: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: semctl(): Invalid argument |
Date: | 2006-04-05 08:25:57 |
Message-ID: | 44337F15.20709@metro.cx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)hub(dot)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(at)hub(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Shellam | 2006-04-05 08:45:47 | Re: PITR Based replication ... |
Previous Message | Robin Iddon | 2006-04-05 08:09:40 | Re: PITR Based replication ... |