Thread: apparent loss of sys tables!! - help
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
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 : : +---------------------------------------+-----------------+
Klint Gore wrote:
7.4.8On 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 : : +---------------------------------------+-----------------+
Attachment
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:
$ 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.87.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
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/
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