Search Postgresql Archives

Re: apparent loss of sys tables!! - help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx           :  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             :                 :
+---------------------------------------+-----------------+
  

begin:vcard
fn:Noel Faux
n:Faux;Noel
org:Monash University;Biochemistry and Molecular Biology
adr:;;;Clayton;Vic;3800;Australia
email;internet:noel.faux@xxxxxxxxxxxxxxxxx
tel;work:+61 03 9905 1418
url:http://vbc.med.monash.edu.au/~fauxn
version:2.1
end:vcard


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux