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

Re: pg_user does not exist

From: Bethany A(dot)Benzur <bethany(at)rawkawn(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_user does not exist
Date: 2004-02-18 18:49:39
Message-ID: 34FBD90C-6243-11D8-9862-000A957A02C8@rawkawn.com (view raw or flat)
Thread:
Lists: pgsql-admin
Argg... I guess I won't be rebuilding template1 from template0 seeing 
as I have no template0!! :(

template1=> UPDATE pg_database SET datallowconn = TRUE
template1-> WHERE datname = 'template0';
UPDATE 0

I'm running out of ideas here... how will I get my databases out and 
back in without pg_dump?

On Feb 18, 2004, at 9:10 AM, Bethany A.Benzur wrote:

>> 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
>
>
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>


In response to

Responses

pgsql-admin by date

Next:From: Shane WrightDate: 2004-02-18 22:19:59
Subject: Re: Mac OS 10.3 Panther make questions
Previous:From: Priya GDate: 2004-02-18 18:40:46
Subject: unsubscribe

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