Skip site navigation (1) Skip section navigation (2)

Re: BUG #4708: \d commands

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Prajakta Patil" <prajaktafirke(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4708: \d commands
Date: 2009-03-16 20:33:09
Message-ID: 24112.1237235589@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Prajakta Patil" <prajaktafirke(at)yahoo(dot)com> writes:
> PostgreSQL version: 7.4.6
> Operating system:   Linux

"Linux" what, exactly?

> when i try to execute \d commands on psql i get error message 
> relation "pg_catalog.pg_user does not exist"

I remembered why this seemed vaguely familar: that's the symptom
of an initdb failure that was caused by buggy ancient versions of
SELinux policy.  "Ancient" here means "right about the same vintage
as PG 7.4.6", cf for instance

http://archives.postgresql.org/pgsql-bugs/2005-03/msg00014.php

so I am wondering if you are running a four-year-old copy of Fedora or
RHEL that has selinux enforcement mode turned on.  If so, do yourself
a favor and get something newer ... there were a LOT of bugs in the
selinux policies back then.  Or you could disable enforcement, but
that wouldn't be a very good idea considering the number of unpatched
security issues that are presumably in that system.  In any case,
the database you have is broken and you should re-initdb after taking
care of the software problem.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: AndreyDate: 2009-03-17 12:01:41
Subject: BUG #4709: dump/restore introduces wrong CHECK constraint for inherited table
Previous:From: Tom LaneDate: 2009-03-16 16:20:58
Subject: Re: BUG #4708: \d commands

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group