Thread: apparent loss of sys tables!! - help

apparent loss of sys tables!! - help

From
Noel Faux
Date:
Hi all,

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!

Cheers
Noel

Attachment

Re: apparent loss of sys tables!! - help

From
Klint Gore
Date:
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?

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             :                 :
+---------------------------------------+-----------------+

Re: apparent loss of sys tables!! - help

From
Noel Faux
Date:
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
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             :                 :
+---------------------------------------+-----------------+ 

Attachment

Re: apparent loss of sys tables!! - help

From
Noel Faux
Date:
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             :                 :
+---------------------------------------+-----------------+ 

Attachment

Re: apparent loss of sys tables!! - help

From
Chris
Date:
Noel Faux wrote:
> 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)

That's the problem then - they need to be the same version (or at least
the same major version - ie both 8.1.x or both 7.4.x).

You'll either need to downgrade the client or upgrade the server.

--
Postgresql & php tutorials
http://www.designmagick.com/

Re: apparent loss of sys tables!! - help

From
Noel Faux
Date:
Chris wrote:
> Noel Faux wrote:
>> 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)
>
> That's the problem then - they need to be the same version (or at
> least the same major version - ie both 8.1.x or both 7.4.x).
>
> You'll either need to downgrade the client or upgrade the server.
>
Ok, it's not a major issue! We're in the process of upgrading the server :)

Cheers
Noel

Attachment