Can't pg_dump
Hello all,
When I try to run pg_dump on any of my databases, I get the
following error:
getInherits(): SELECT failed. Explanation returned from backend:
'ERROR: attribute 'inhrel' not found'.
I've no idea why this should appear, as the databases only use
built-in types. We're using 7.0.3, and I'm trying to dump the
databases so as to upgrade to the latest version.
Many thanks in advance.
--Ray.
---------------------------------------------------------
Raymond O'Donnell http://www.iol.ie/~rod/organ
rod@iol.ie The Irish Pipe Organ Page
---------------------------------------------------------
"Raymond O'Donnell" <rod@iol.ie> writes:
When I try to run pg_dump on any of my databases, I get the
following error:
getInherits(): SELECT failed. Explanation returned from backend:
'ERROR: attribute 'inhrel' not found'.
IIRC, this is the symptom of using a pre-7.0 pg_dump with a 7.0 backend;
more recent pg_dump versions warn you if they see a server version
mismatch.
regards, tom lane
On 11 Dec 2001, at 9:09, Tom Lane wrote:
getInherits(): SELECT failed. Explanation returned from backend:
'ERROR: attribute 'inhrel' not found'.IIRC, this is the symptom of using a pre-7.0 pg_dump with a 7.0
backend; more recent pg_dump versions warn you if they see a server
version mismatch.
Fair enough. I had assumed that pg_dump was installed along with
the rest of Postgres, but apparently not. I've been huntong around
on the website, but I can't see how to get hold of pg_dump on its
own without having to get everything else as well - is this possible?
--Ray.
---------------------------------------------------------
Raymond O'Donnell http://www.iol.ie/~rod/organ
rod@iol.ie The Irish Pipe Organ Page
---------------------------------------------------------
Import Notes
Resolved by subject fallback