SELinux & Redhat

I think we should put some notes about SELinux causing issues with
pgsql in the OS notes or FAQ.

Myself and a few coworkers just spent a few hours tracking down why
pg_dump would produce no output. We'd fire it up in strace and we'd
see all the successful write calls, but not output.

We copied pg_dump from another machine and it worked fine, and that
machine was running the same OS & pg rpms.

Eventually we found it was SELinux was preventing pg_dump from
producing output.

Any thoughts? I could write up a short blurb but I'm not terribly
familiar with selinux. we just disabled the whole thing to make it work.

For the record:
CentOS 4.0
postgresql-8.0.2-1PGDG.i686.rpm (and associated) rpms from
postgresql.org's ftp server

--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/