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?
[EMAIL PROTECTED] ]$ 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: [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org