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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
