Re: ERROR: relation "pg_catalog.pg_user" does not exist

Lists: pgsql-bugs
From: guru(at)ap(dot)nic(dot)in
To: pgsql-bugs(at)postgresql(dot)org
Cc: jannapurna(at)gmail(dot)com
Subject: ERROR: relation "pg_catalog.pg_user" does not exist
Date: 2007-02-23 06:03:32
Message-ID: 32967.10.160.2.41.1172210612.squirrel@apsu.ap.nic.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

we have installed Linux advanced server-4 and the postgres-7.4.6.
when we execute \d command following error is displaying

ERROR: relation "pg_catalog.pg_user" does not exist

The database otherwise works correctly. I can create tables, load
data, etc.
regards
Guru


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: guru(at)ap(dot)nic(dot)in
Cc: pgsql-bugs(at)postgresql(dot)org, jannapurna(at)gmail(dot)com
Subject: Re: ERROR: relation "pg_catalog.pg_user" does not exist
Date: 2007-02-23 07:02:21
Message-ID: 12711.1172214141@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

guru(at)ap(dot)nic(dot)in writes:
> we have installed Linux advanced server-4 and the postgres-7.4.6.
> when we execute \d command following error is displaying
> ERROR: relation "pg_catalog.pg_user" does not exist

I don't know what "Linux advanced server-4" means, but if it's RHEL4
and you've got SELinux enabled, this is a known problem with early
releases of the SELinux policy for Postgres --- some steps of the
initdb process fail due to permissions problems, leaving you with
missing system views and such. Get a more recent release. You
*definitely* need something more recent than 7.4.6 as far as Postgres
itself is concerned; we're up to 7.4.16 in that branch, not to mention
that 7.4.anything is old...

regards, tom lane