[CentOS] PostgreSQL/SELinux Error - relation "pg_catalog.pg_user" does not exist

Tue May 24 09:48:16 UTC 2005
Gavin Carr <gavin at openfusion.com.au>

Hi Matt,

On Tue, May 24, 2005 at 02:53:21PM +0800, Matt Arnilo S. Baluyos (Mailing Lists) wrote:
> i'm trying to run a postgresql service on my newly-installed centos4
> box. i have been able to recreate my users, set up the permissions,
> and restore the database dump. also, i can already log-in to my
> databases.
> 
> there is, however, one annoying problem. whenever i type \du (or \d or
> \l) on the psql prompt, i get the following error:
> 
> ERROR:  relation "pg_catalog.pg_user" does not exist

Yep, I came across this a couple of months ago - it's an selinux bug on
postgres initialisation:

  https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=150979

There's an updated policy in that thread that fixes the problem, and
it'll be included in the upcoming RHEL4 U1.

Cheers,
Gavin