Re: initdb dies during IpcSemaphoreCreate under BSD jail

> -----Original Message-----
> From: Joseph Maxwell [mailto:jemaxwell(at)jaymax(dot)com]
> Sent: Wednesday, June 19, 2002 6:52 AM
> To: Joel Burton
> Cc: Pgsql-General(at)Postgresql(dot) 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(at)joelburton | www.joelburton.com | aim:wjoelburton
Information Technology & Knowledge Management Consultant