Re: pg_catalog.pg_roles DESTROYED?

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

In response to

Browse pgsql-admin by date

  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