[CentOS] PostgreSQL/SELinux Error - relation "pg_catalog.pg_user" does not exist
Rudi Starcevic
tech at wildcash.com
Tue May 24 08:02:05 UTC 2005
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
>
>
More information about the CentOS
mailing list