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