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

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 (view raw or flat)
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

pgsql-admin by date

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

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