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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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