Re: [NOVICE] pg_dump problem - Mailing list pgsql-admin

From Tom Lane
Subject Re: [NOVICE] pg_dump problem
Date
Msg-id 25359.964217159@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump problem  (John Burski <jburski@autopartshq.com>)
List pgsql-admin
John Burski <jburski@autopartshq.com> writes:
> When I issue the "pg_dump jcon" (jcon being the database name, of
> course) I receive the following error message:

>      getInherits():  SELECT failed

It might be time to put this in the FAQ ;-).  You're probably trying
to run a 6.5 (or earlier?) pg_dump against a 7.0 database.  The older
pg_dump doesn't do any version checking, and the first it realizes
it's got trouble is when it hits incompatibilities in the system
table layout.

Check your PATH to see where pg_dump is coming from...

            regards, tom lane

pgsql-admin by date:

Previous
From: John Burski
Date:
Subject: pg_dump problem
Next
From: John Burski
Date:
Subject: Re: [NOVICE] pg_dump problem