postgres in freebsd jail

> 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

Have you enabled jail.sysvipc_allowed 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

"Reko Turja" <re********@liukuma.net> wrote:

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

Have you enabled jail.sysvipc_allowed 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.

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 ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

On Mon, 16 Aug 2004, Bill Moran wrote:

"Reko Turja" <re********@liukuma.net> wrote:

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

Have you enabled jail.sysvipc_allowed 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.

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 database that runs pgfoundry.org/gborg.postgresql.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: sc*****@hub.org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

----- Original Message -----
From: "Bill Moran" <wm****@potentialtech.com>

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.

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