From: | Ralph Smith <smithrn(at)u(dot)washington(dot)edu> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | pg_catalog.pg_roles DESTROYED? |
Date: | 2007-08-03 00:07:21 |
Message-ID: | A4745D59-38DA-4B40-A7EB-07611FC4DD46@u.washington.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I'm preparing to upgrade a 7.4.7 DB to 8.2.4.
I just got connectivity from new to old (different hosts), and being
a newhire and no-one had ever done any maintenance on the old DB, I
connected as joe-user to the old DB using the client of the new.
(joe-user is the owner of the DB)
I did some analyze and vacuum-ing on two tables.
The last thing I did there was
>vacuum full verbose tablename;
I did it twice to see the differing results.
It was HUGE and now is smaller.
I next tried to do a \dt and suddenly....
airburst=> \dt
ERROR: relation "pg_catalog.pg_roles" does not exist
None of the \d - commands work.
Only if I go in as PG super can I avoid that error. (Going in
locally after logging into that box.)
I'm new to PG myself, so I'd appreciate it if I had some hand-holding.
Thank you!
Ralph Smith
From | Date | Subject | |
---|---|---|---|
Next Message | Phillip Smith | 2007-08-03 00:26:19 | Re: pg_catalog.pg_roles DESTROYED? |
Previous Message | Dimitri Gritsenko | 2007-08-02 08:26:47 | Wal standbies switchover |