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.faux@med.monash.edu.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.faux@med.monash.edu.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@kgb.une.edu.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             :                 :
+---------------------------------------+-----------------+