Re: pg_user does not exist

From: Bethany A(dot)Benzur <bethany(dot)benzur(at)oit(dot)gatech(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_user does not exist
Date: 2004-02-18 14:10:18
Message-ID: 2E59D325-621C-11D8-9862-000A957A02C8@oit.gatech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> Hmmm ... I'm wondering about version mismatches between your psql and
> your backend. Does "psql -V" agree with the backend version?

[bj56(at)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(at)iac(dot)gatech(dot)edu

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message GP 2004-02-18 15:21:15 PL/pgSQL instalLation problem ??
Previous Message Jeff Boes 2004-02-18 12:54:23 Re: HELP - need way to restore only blobs