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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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


[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux