Re: pg_user does not exist - Mailing list pgsql-admin

From Bethany A.Benzur
Subject Re: pg_user does not exist
Date
Msg-id 2E59D325-621C-11D8-9862-000A957A02C8@oit.gatech.edu
Whole thread Raw
In response to Re: pg_user does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_user does not exist
List pgsql-admin
> Hmmm ... I'm wondering about version mismatches between your psql and
> your backend.  Does "psql -V" agree with the backend version?

[bj56@steel ]$ psql -V
psql (PostgreSQL) 7.2.4

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

Yes, the same "pg_user does not exist" occurs with each database (hence
my not being able to dump + restore). I assume that is the case because
each database is based off of template1 when it is created.

I will try reconstructing template1 from template0 - thanks for that
link!

this a great start - thanks!
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@iac.gatech.edu


pgsql-admin by date:

Previous
From: Jeff Boes
Date:
Subject: Re: HELP - need way to restore only blobs
Next
From: Warren Little
Date:
Subject: Re: HELP - need way to restore only blobs