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