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@centos.org http://lists.centos.org/mailman/listinfo/centos