Re: apparent loss of sys tables!! - help

On the client machine:
$ psql --version
psql (PostgreSQL) 8.1.3

At the host:
monashprotein=> select version();
version
-------------------------------------------------------------------------------------------------
PostgreSQL 7.4.8 on ia64-unknown-linux-gnu, compiled by GCC gcc (GCC)
3.3.5 (Debian 1:3.3.5-13)
(1 row)

Please reply to all, ensuring that the post is placed on the
pqsql-general mailing list.

Klint Gore wrote:
> On Thu, 16 Mar 2006 12:51:03 +1100, Noel Faux <noel(dot)faux(at)med(dot)monash(dot)edu(dot)au> wrote:
>
>> This is a multi-part message in MIME format.
>>
>> ----------------------------------------------------------------
>> Klint Gore wrote:
>>
>>> On Thu, 16 Mar 2006 12:33:26 +1100, Noel Faux <noel(dot)faux(at)med(dot)monash(dot)edu(dot)au> wrote:
>>>
>>>
>>>> Has anyone had this problem?
>>>>
>>>> while in psql:
>>>>
>>>> monashprotein=> \d alignment
>>>> ERROR: column c2.reltablespace does not exist
>>>> monashprotein=> \d region
>>>> ERROR: column c2.reltablespace does not exist
>>>> monashprotein=>
>>>> monashprotein=> \d
>>>> ERROR: relation "pg_catalog.pg_roles" does not exist
>>>>
>>>>
>>>> Any pointers would be really appreciated!
>>>>
>>>>
>>> are you using an 8.x psql against a 7.x database?
>>>
>>>
>> 7.4.8
>>
>
> 7.4.8 doesn't have tablespaces so the version of psql that you have must
> be a 8.x?
>
> if you run "psql --version", does it say 7.4.8 or 8.x.x?
> if you execute the query "select version();" what does it say?
>
> I've got 8.1 on my workstation with 7.4.7 on a development server (dev1)
> and it says the following -
>
> D:\>psql --version
> psql (PostgreSQL) 8.1.0
>
> D:\>psql -h dev1 template1
> template1=# select version();
> version
>
> ---------------------------------------------------------------------------------------------------------
> PostgreSQL 7.4.7 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
> (1 row)
>
> template1=# \d
> ERROR: relation "pg_catalog.pg_roles" does not exist
> template1=# \d pg_class
> ERROR: column c2.reltablespace does not exist
> template1=#
>
> klint.
>
> +---------------------------------------+-----------------+
> : Klint Gore : "Non rhyming :
> : EMail : kg(at)kgb(dot)une(dot)edu(dot)au : slang - the :
> : Snail : A.B.R.I. : possibilities :
> : Mail University of New England : are useless" :
> : Armidale NSW 2351 Australia : L.J.J. :
> : Fax : +61 2 6772 5376 : :
> +---------------------------------------+-----------------+
>