postgres in freebsd jail

[Vikram]

Hi,

I am using postgresql 8.0beta in a freebsd jail environment. My inittdb
gives me a message like:
---
creating template1 database in /home/..../db/base/1 ... FATAL: could
not create shared memory segment: Function not implemented
DETAIL: Failed system call was shmget(key=1, size=1187840, 03600).
child process exited with exit code 1
initdb: failed
---

I searched the archives and saw discussions regarding this but could not
find any definitive answer in them. Is this problem still current?

Thanks,
Vikram



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Reko Turja]

Re: postgres in freebsd jail

> I am using postgresql 8.0beta in a freebsd jail environment. My[color=blue]
> inittdb
> gives me a message like:
> ---
> creating template1 database in /home/..../db/base/1 ... FATAL:
> could
> not create shared memory segment: Function not implemented
> DETAIL: Failed system call was shmget(key=1, size=1187840, 03600).
> child process exited with exit code 1
> initdb: failed[/color]

Have you enabled jail.sysvipc_al lowed sysctl for kernel? I haven't run
Postgresql in jail myself but as far as I know the sysctl above is
needed in order to use sysv IPC and shared memory functionality inside
the jail.

-Reko


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Bill Moran]

Re: postgres in freebsd jail

"Reko Turja" <reko.turja@liu kuma.net> wrote:
[color=blue][color=green]
> > I am using postgresql 8.0beta in a freebsd jail environment. My
> > inittdb
> > gives me a message like:
> > ---
> > creating template1 database in /home/..../db/base/1 ... FATAL:
> > could
> > not create shared memory segment: Function not implemented
> > DETAIL: Failed system call was shmget(key=1, size=1187840, 03600).
> > child process exited with exit code 1
> > initdb: failed[/color]
>
> Have you enabled jail.sysvipc_al lowed sysctl for kernel? I haven't run
> Postgresql in jail myself but as far as I know the sysctl above is
> needed in order to use sysv IPC and shared memory functionality inside
> the jail.[/color]

I was unable to get Postgres working in a jail even with this sysctl
enabled. If you look through the archives, you'll see a discussion with
others who have it working just fine.

The upshot is that, personally, I don't know. I have not yet had time to
track down the problem.

--
Bill Moran
Potential Technologies

http://www.potentialtech.com

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postg resql.org so that your
message can get through to the mailing list cleanly

[Marc G. Fournier]

Re: postgres in freebsd jail

On Mon, 16 Aug 2004, Bill Moran wrote:
[color=blue]
> "Reko Turja" <reko.turja@liu kuma.net> wrote:
>[color=green][color=darkred]
>>> I am using postgresql 8.0beta in a freebsd jail environment. My
>>> inittdb
>>> gives me a message like:
>>> ---
>>> creating template1 database in /home/..../db/base/1 ... FATAL:
>>> could
>>> not create shared memory segment: Function not implemented
>>> DETAIL: Failed system call was shmget(key=1, size=1187840, 03600).
>>> child process exited with exit code 1
>>> initdb: failed[/color]
>>
>> Have you enabled jail.sysvipc_al lowed sysctl for kernel? I haven't run
>> Postgresql in jail myself but as far as I know the sysctl above is
>> needed in order to use sysv IPC and shared memory functionality inside
>> the jail.[/color]
>
> I was unable to get Postgres working in a jail even with this sysctl
> enabled. If you look through the archives, you'll see a discussion with
> others who have it working just fine.[/color]

The database that runs pgfoundry.org/gborg.postgresq l.org and
www.postgresql.org are in a jail ... so definitely know it works ... as to
the above error, my first thing to check would be as Reko mentioned, check
that ipc within jail is allowed ...

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postg resql.org

[Reko Turja]

Re: postgres in freebsd jail

----- Original Message -----
From: "Bill Moran" <wmoran@potenti altech.com>
[color=blue]
> I was unable to get Postgres working in a jail even with this sysctl
> enabled. If you look through the archives, you'll see a discussion
> with
> others who have it working just fine.
>
> The upshot is that, personally, I don't know. I have not yet had
> time to
> track down the problem.[/color]

I guess you have set the following variables according your needs in
your kernel config file and then recompiled your kernel?

options SYSVSHM
options SYSVSEM
options SYSVMSG
options SHMMAXPGS=65536
options SEMMNI=40
options SEMMNS=240
options SEMUME=40
options SEMMNU=120

I don't have a system running -CURRENT or 5.x at this moment, so I
can't check if there are new sysctl's or kernel variables introduced,
which control the SYSV - One possible thing to do would be grepping
the output of sysctl -a and checking for word jail. (I tried to find
the thread you mentioned, but only found one post from you, so I'm
sorry if I'm just repeating the obvious...)

-Reko


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html