Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group