Re: Using an alternate PGDATA on RHEL4 with SELinux enabled

"David Esposito" <pgsql-general@esposito.newnetco.com> writes:
> I just tried installing Postgres 8.1.4 (RPMs from postgresql.org web site)
> on a clean RHEL4 Update 2 machine that had SELinux enabled.
> When I created a /etc/sysconfig/pgsql/postgresql config file with
> PGDATA=/data/pgdata
> I was unable to get the start script (/etc/init.d/postgresql) to populate
> the data directory nor launch postgres (after I manually did an initdb on
> the directory)

The default selinux policy prevents postgres from writing anywhere
except under /var/lib/pgsql.  If you want a nondefault PGDATA location
then you have to tweak the policy.

            regards, tom lane