initdb: failed
We are running Postgresql 7.4.7 on Redhat EL 4. Running /usr/bin/initdb
command as user postgres fails before creating the views such as pg_user
and pg_rules.
It does create the database directories and databases. We can access
them, add tables, and data. But pg_dump fails to do anything (no error
messages, just nothing).
Can anyone help us out?
Kathy
Katherine Boyle
NetTec Services
1385 Beulah Rd.
Pittsburgh, PA 15235
412-349-2215 Direct Dial
412-823-7676 Fax
-----
This electronic mail transmission and any files transmitted with it contain confidential information intended only for the person(s) named. Any use, distribution, copying or disclosure by another person is strictly prohibited. Any opinions implied or expressed in this e-mail are those of the individual sending it, and are not necessarily the opinion of NetTec Services.
"Kathy Boyle" <KBoyle@nettec.com> writes:
We are running Postgresql 7.4.7 on Redhat EL 4. Running /usr/bin/initdb
command as user postgres fails before creating the views such as pg_user
and pg_rules.
This is a known problem caused by SELinux security enforcement. The
quick and dirty solution is to do setenforce 0, at least for long enough
to run initdb. But I'd recommend updating to the most recent available
postgresql and selinux-policy-targeted RPMs, which should resolve the
issue properly. (You may need to run restorecon on the /usr/bin and
/var/lib/pgsql trees after updating; I'm not sure that simply updating
the policy RPM will adjust the file security labels correctly.)
regards, tom lane