Postgres Pro
Downloads
Home   >   mailing lists

Thread: Can't pg_dump

Can't pg_dump

From
"Raymond O'Donnell"
Date:
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
---------------------------------------------------------

Re: Can't pg_dump

From
Tom Lane
Date:
"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

Re: Can't pg_dump

From
"Raymond O'Donnell"
Date:
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
---------------------------------------------------------