Thread: BUG #1764: newbie

The following bug has been logged online:

Bug reference:      1764
Logged by:          john cecilio
Email address:      j.diegor@gmail.com
PostgreSQL version: 7.4.8
Operating system:   CentOS 4.0 (updated to 4.1)
Description:        newbie
Details:

Im getting error in pg_user,

"ERROR: Relation 'pg_user' does not exist"

What should I do with this? I think pg_user is not existing on my system.
(just a wild guess). I use the installer include in the CentOS setup and use
the full installation. When Im using the pgAdmin3/phpPgAdmin the error
always shows up but if I use the terminal in accessing postgresql it doesn't
shows up frequently, but Im just a newbie in postgresql. Im not really
familiar in all commands/syntax thats why im trying pgAdmin3/phpPgAdmin.

Is there anything I should setup first to have the 'pg_user'?

Hope you could help me on this. Thank you for your time.

"john cecilio" <j.diegor@gmail.com> writes:
> Operating system:   CentOS 4.0 (updated to 4.1)

> Im getting error in pg_user,
> "ERROR: Relation 'pg_user' does not exist"

> What should I do with this?

Turn off SELinux enforcement, then shut down the postmaster and remove
everything under /var/lib/pgsql/data/, then restart the postmaster.

Apparently CentOS is still shipping the versions of postgresql and
selinux-policy-targeted that did not play nicely together.  Personally
I'd recommend Fedora ;-)

            regards, tom lane