Re: Jailed postgres - Mailing list pgsql-novice

From Marc G. Fournier
Subject Re: Jailed postgres
Date
Msg-id 20031028100738.J58363@ganymede.hub.org
Whole thread Raw
In response to Jailed postgres  (Paul Bauer <paul@shorttermwhat.com>)
List pgsql-novice

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


pgsql-novice by date:

Previous
From: Paul Bauer
Date:
Subject: Jailed postgres
Next
From: "Eric S. Johansson"
Date:
Subject: logging messages this time