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
