initdb dies during IpcSemaphoreCreate under BSD jail

Hi Joel,
Did you ever get any resolution to this problem? I am facing it now and need
some
direction.
Thanks
---   Joe   ---

Joel Burton wrote:

-----Original Message-----
From: Joseph Maxwell [mailto:jemaxwell@jaymax.com]
Sent: Wednesday, June 19, 2002 6:52 AM
To: Joel Burton
Cc: Pgsql-General@Postgresql. Org
Subject: Re: [GENERAL] initdb dies during IpcSemaphoreCreate under BSD
jail

Did you ever get any resolution to this problem? I am facing it
now and need
some
direction.

Joel Burton wrote:

I'm working on a site hosted in a BSD Jail; they have MySQL

installed but,

of course, I'd rather use PostgreSQL.

It installs fine but can't initdb; get the following:

Fixing permissions on existing directory /usr/local/pgsql/data... ok
creating directory /usr/local/pgsql/data/base... ok
creating directory /usr/local/pgsql/data/global... ok
creating directory /usr/local/pgsql/data/pg_xlog... ok
creating directory /usr/local/pgsql/data/pg_clog... ok
creating template1 database in /usr/local/pgsql/data/base/1...
IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed:
Function not implemented

Earlier message traffic suggests that SYSV IPC has not been fixed to run
under BSD Jails.

The last time this was raised was ~1 year ago. Has there been

any changes

here that anyone knows of? Any hope of getting PG running in

our jail? (Or,

alternatively, can PG run on the real machine's processes so that the
different jails can access it?)

Several people offered a suggestion of settings that could be made outside
of the BSDjail that would apparently allow the jails access to
non-jail-specific-shared SYSV IPC. While people though this would work fine
and was without serious risk, my ISP (imeme.net) refused to make this change
and wouldn't explain why. I don't run a BSD box of my own, so I can't say
that it would have worked, but I trust the people that, in many cases at
least, it would have. Search the ML archives for the details on what to
change; I don't remember what they are.

There's been some discussion recently about abstracting some of the shared
memory/IPC stuff differently, mostly to allow native ports to Win32. I had
some hope that this would allow use of PG on places w/o functional SYSV IPC
(such as our BSD jails), but tgl said (IIRC) this wouldn't fix the problem
unless someone rewrote this specifically for the jail setup.

My workaround for this situation, unfortunately, has to been to stay with
MySQL for this project. Gotta love the lack of subselects and views, hmmm?

- J.

--
Joel BURTON | joel@joelburton | www.joelburton.com | aim:wjoelburton
Information Technology & Knowledge Management Consultant