Hello, >> ERROR: relation "pg_catalog.pg_user" does not exist This looks like a Postgresql error, perhaps the very cool SeLinux is not the problem. Pg_catalog is an internal Pg system table. I run Postgresql on several flavours of Linux and FreeBSD. I feel I get a installation by compiling the software all in /usr/local/pgsql. It's also easier to manage across the various OS's. As this seems Pg related I recommend the Postgresql user mailing list: www.postgresql.org Compiling is very simple see: www.oreilly.com/catalog/p*postgresql*/*chapter*/ch02.pdf Postgresql is a very advanced piece of software with lots of configuration options, I have found study the books and compiling has fast-tracked my understanding of the awesome software. I hope this helps, just my 2 cents :-) Cheers, Rudi Peter Farrow wrote: > 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 >> >> >> > > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos > >