From: | Ralph Smith <smithrn(at)u(dot)washington(dot)edu> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_catalog.pg_roles DESTROYED? |
Date: | 2007-08-03 17:39:27 |
Message-ID: | 374EF750-3818-4075-96ED-EFA6A78590A2@u.washington.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Aug 2, 2007, at 5:26 PM, Stephan Szabo wrote:
>
> On Thu, 2 Aug 2007, Ralph Smith wrote:
>
>> 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
>
> Which version of psql were you using? psql doesn't really have good
> support for backslash commands where the server and client are of
> mixed
> versions -- for example, an 8.2.x psql will look for system tables
> that
> didn't exist in 7.4.x.
======================
A big sigh of relief!
Actually on the way home last night I thought I ought to try as joe-
user locally on that box, but your (plural) comments were nice to
read before I got here to test it out myself.
Thank you both,
Ralph
From | Date | Subject | |
---|---|---|---|
Next Message | ekzept | 2007-08-03 21:09:50 | libpq.dll as part of PGDB module: access to PostgreSQL from Python |
Previous Message | Казорез Александр Олегович | 2007-08-03 12:57:29 | Help |