Re: Alternate DB location continued.

On Fri, 18 Feb 2005, Bob Hartung wrote:

> Hi again all.
> Here is the situation:
> Fedora Core 3 with all updates.
> PostgreSQL 8.0.1 installed - no tables to update.
> In /etc/profile I have declared:
> PGDATA=/pg_data
> PATH=$PATH:$PGDATA
> export PGDATA
> export PATH
>
> Directory /pg_data exists and is owned by postgres.
> Log in as user postgres and run initdb by itself or with
> -D PGDATA
> -D /pg_data
>
> The output is as follows:
> The files belonging to this database system will be owned by user
> "postgres?.
> This user must also own the server process.
> The database cluster will be initialized with local en_US.UTF-8.
> The default database encoding has accordingly been set to UNICODE.
>
> fixing permissions on existing directory /pg_data . . . ok
> creating directory /pg_data/global ... ok
> creating directory /pg_data/pg_xlog ... ok
> creating directory /pg_data/pg_xlog/archive_status ... ok
> creating directory /pg_data/pg_clog ... ok
> creating directory /pg_data/pg_subtrans ... ok
> creating directory /pg_data/base ... ok
> creating directory /pg_data/base/1 ... ok
> creating directory /pg_data/pb_tblspc ... ok
> selecting default max_connections ... 10
> selecting default shared_buffers ... 50
> creating configuration files ... ok
> creating template1 database in /pg_data/base/1 ... child process
> exited with exit code 1
> initdb: removing contents of data directory "/pg_data"
>
> Does anyone have any idea of where I went wrong? If do not declare and
> export PGDATA or append it to path, everything works fine.
>
> Thanks again for your time. If you responded the other day I may have
> lost your message as I was on the road.

Please read replies here:
http://archives.postgresql.org/pgsql-general/2005-02/msg00832.php

As Tom wrote, it's likely it's SElinux in action.

.TM.
--
____/ ____/ /
/ / / Marco Colombo
___/ ___ / / Technical Manager
/ / / ESI s.r.l.
_____/ _____/ _/ Colombo(at)ESI(dot)it