Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id EAD3C9FB7AF for ; Thu, 2 Aug 2007 21:26:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 20489-07 for ; Thu, 2 Aug 2007 21:26:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by postgresql.org (Postfix) with ESMTP id 2A45D9FB963 for ; Thu, 2 Aug 2007 21:26:43 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 25C05354A8; Thu, 2 Aug 2007 17:26:42 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 2420C354A2; Thu, 2 Aug 2007 17:26:42 -0700 (PDT) Date: Thu, 2 Aug 2007 17:26:42 -0700 (PDT) From: Stephan Szabo To: Ralph Smith Cc: pgsql-admin@postgresql.org Subject: Re: pg_catalog.pg_roles DESTROYED? In-Reply-To: Message-ID: <20070802172214.F27939@megazone.bigpanda.com> References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/18 X-Sequence-Number: 26349 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.