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
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 |