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';
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
> 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
> ---------------------------(end of
> TIP 8: explain analyze is your friend
In response to
pgsql-admin by date
|Next:||From: Shane Wright||Date: 2004-02-18 22:19:59|
|Subject: Re: Mac OS 10.3 Panther make questions|
|Previous:||From: Priya G||Date: 2004-02-18 18:40:46|