| From: | Bethany A(dot)Benzur <bethany(dot)benzur(at)oit(dot)gatech(dot)edu> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: pg_user does not exist |
| Date: | 2004-02-18 14:10:18 |
| Message-ID: | 2E59D325-621C-11D8-9862-000A957A02C8@oit.gatech.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | GP | 2004-02-18 15:21:15 | PL/pgSQL instalLation problem ?? |
| Previous Message | Jeff Boes | 2004-02-18 12:54:23 | Re: HELP - need way to restore only blobs |