Re: Jailed postgres

On Mon, 27 Oct 2003, Paul Bauer wrote:

> I hope this is ok on this list.  I am currently using postgres 7.2 on my
> host machine for some internal information.
>
> I recently created a jail for my apache server and want to install
> postgres (7.3) in it.  I am finding that it is nearly impossible to get this
> working.
>
> $ initdb -D /usr/local/pgsql/data
> The files belonging to this database system will be owned by user
> "pgsql".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.
>
> creating 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

Add:

jail.sysvipc_allowed=1

to our /etc/sysctl.conf file