Re: Relation 'pg_user' does not exist

On Wed, Nov 08, 2000 at 08:40:08PM -0500, Tom Lane wrote:
> Matt Beauregard <matt(at)designscape(dot)com(dot)au> writes:
> >> The plot thickens ... what did you say the error message was
> > exactly?
>
> > !759 marauder(at)bofh:~$ pg_dump -h tweedledee ds
> > getTypes(): SELECT failed. Explanation from backend: 'ERROR:
> > Relation 'pg_user' does not exist
>
> > NOTICE: mdopen: couldn't open pg_user: No such file or directory
>
> This is strange in itself. There should be an (empty) file named
> pg_user in your $PGDATA/base/template1 directory --- is there?
> What about pg_views?

Neither are there.

> Hmm. Tracing this back makes it appear that the pg_user row in pg_class
> isn't being found by an index scan. Since the row clearly is there when
> you do a sequential scan, this suggests that the pg_class_relname_index
> index is corrupted. If so, how'd it get that way? Is there a
> pg_class_relname_index file in template1? How big is it?

There, 16384 bytes.

> One thing I am wondering about, since you mention restarting the
> postmaster, is whether you're being careful to start the postmaster
> in a consistent environment --- in particular, with consistent
> LOCALE-related environment variable values. A number of people have

That doesn't sound like something we'd ever change... I've never
explicitly been careful about the environment but I can't think of a
reason for it not to be the same between starts.

--
Matt Beauregard
Information Technology Operations, DesignScape

Ph: +61 2 9361 4233 Fx: +61 2 9361 4633