pg_user does not exist

From: Bethany A(dot)Benzur <bethany(dot)benzur(at)oit(dot)gatech(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_user does not exist
Date: 2004-02-18 00:01:31
Message-ID: 9B5FE928-61A5-11D8-9862-000A957A02C8@oit.gatech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,
I have been running postgres for quite some time with this problem:
whenever a user logs in or issues almost any command in the "psql"
client, they get this error:

-bash-2.05b$ psql
ERROR: Relation "pg_user" does not exist

postgres=> \l
ERROR: Relation "pg_user" does not exist

postgres=> \dt
ERROR: Relation "pg_user" does not exist

etc...

At first I thought it had something to do with my using ident
authentication, but after some research it seems my "template1"
database is corrupt and missing some pretty essential elements. If I
could just build a new template1 or run initdb again, everything might
be OK... but the problem here is that there isn't much I can do without
being able to use pg_dump to export/backup my databases first!!

I even tried editing the initdb script and the postgres.bki file to
only run certain parts of the init process, like creating the views and
such... which DID eliminate the "pg_user does not exist" error, but
also created big messes with the other databases (like creating
multiple pg_database tables and erasing all other database's data).
Oops! Luckily restoring was as easy as "mv data.bak data" . :)

So, before I spend any more time playing with the my customized initdb
and postgres.bki, does anyone have any better ideas of how I might:

a) rebuild template1 to get to a point where I can pg_dump my
databases, reinstall postgres or re-initdb, then import the databases
-OR-
b) export the databases without having a pg_user view??

The server is running:
Redhat 8.0
postgresql-7.2.4-5.80

I'm not even sure if I'm on the right track here, so any help is much
appreciated!!
B.
--
Bethany A. Benzur
Computer Support Specialist IV
School of Literature, Communication, and Culture at Georgia Institute
of Technology
phone: 404.894.7632
helpdesk: lcc-support(at)iac(dot)gatech(dot)edu

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Perez 2004-02-18 02:29:43 Re: Mac OS 10.3 Panther make questions
Previous Message Tom Lane 2004-02-17 23:59:51 Re: large objects missing