X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D3518D1D1CD for ; Wed, 18 Feb 2004 04:06:04 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 59567-06 for ; Wed, 18 Feb 2004 00:06:03 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id DC382D1B4E0 for ; Wed, 18 Feb 2004 00:06:02 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1I460LY020289; Tue, 17 Feb 2004 23:06:01 -0500 (EST) To: "Bethany A.Benzur" Cc: pgsql-admin@postgresql.org Subject: Re: pg_user does not exist In-reply-to: <9B5FE928-61A5-11D8-9862-000A957A02C8@oit.gatech.edu> References: <9B5FE928-61A5-11D8-9862-000A957A02C8@oit.gatech.edu> Comments: In-reply-to "Bethany A.Benzur" message dated "Tue, 17 Feb 2004 19:01:31 -0500" Date: Tue, 17 Feb 2004 23:06:00 -0500 Message-ID: <20288.1077077160@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/266 X-Sequence-Number: 12440 "Bethany A.Benzur" writes: > 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 Hmmm ... I'm wondering about version mismatches between your psql and your backend. Does "psql -V" agree with the backend version? > 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!! You can rebuild template1 from template0 (... that's pretty much why template0 exists...). There are some gotchas in this process, see this link for a walkthrough: http://techdocs.postgresql.org/techdocs/pgsqladventuresep1.php However, I am not totally convinced that that's where your problem is. Do you see failures when you are connected to other databases besides template1? regards, tom lane