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: (view raw, whole thread or download thread mbox)
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 

this a great start - thanks!

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


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-2017 The PostgreSQL Global Development Group