Bethany A.Benzur
2004-02-18 00:01:31 UTC
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-***@iac.gatech.edu
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
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-***@iac.gatech.edu
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster