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

[Peter Farrow]

Just turn off SELinux, it really is a complete pain.

I've managed to set up Linux and Unix boxes securely for years without 
all the SE Linux baggage.....

All it does is slow the machine down, and adds "bloat" to the OS...

P.


Matt Arnilo S. Baluyos (Mailing Lists) wrote:

>hello everyone,
>
>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
>
>after some googling, i'm beginning to suspect that this is a SELinux
>issue. i then try to disable SELinux on the postgresql daemon by
>doing:
>
># setsebool postgresql_disable_trans true
>
>that does not work unfortunately as i'm still stuck with the same error.
>
>while i can definitely just disable SELinux on this box, i would want
>a more elegant solution that solves this annoying problem. can anyone
>help me on this?
>
>thanks in advance!
>matt
>
>  
>