From: | Nigel Gilbert <n(dot)gilbert(at)soc(dot)surrey(dot)ac(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | getInherits(): SELECT failed. |
Date: | 2001-07-26 22:49:46 |
Message-ID: | 20010726224913.VVXY283.mta07-svc.ntlworld.com@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have inherited a database apparently set up using postgres7.0.2. I
now want to dump the database in preparation for tidying up and
upgrading to the current version of postgresql. However, pg_dumpall
gives:
pg_dumpall >db.out
getInherits(): SELECT failed. Explanation from backend: 'ERROR:
Attribute 'inhrel' not found
'.
A previous message in this list proposed that this error was generated
when a version 6 database is dumped using version 7 software. I think
this is unlikely to be the explanation here (for example, psql 7.0.2
reads the database without complaint), but it is a possibility. My
questions for the list:
1. How do I find the version numbers of (a) the database and (b) the
pg_dump code, given that I am not certain about their past history.
2. More importantly, how do I work around the error, so that I can dump
the database and move up to version 7.1?
Cheers,
Nigel
From | Date | Subject | |
---|---|---|---|
Next Message | Mike C | 2001-07-26 23:40:12 | Running Postmaster - PGDATA Variable |
Previous Message | Nathan Myers | 2001-07-26 22:13:34 | Re: Bad timestamp external representation |