Thread: an error while pg_dumpall

an error while pg_dumpall

From
"Partyka Robert"
Date:
Hi,

I get such error while trying to dumpall db on PostgreSQL 7.0.3

[postgres@trinity pgsql]$ pg_dumpall -p 5555 -d | gzip >
/admins/PGBACK/baza-last-all.sql.gz
getInherits(): SELECT failed.  Explanation from backend: 'ERROR:
Attribute 'inhrel' not found
'.
pg_dump failed on trinity_admins_db, exiting

What have I missed ?

And by the way. pg_dumpall ignore "-p PORT" option. When I dont
set $PGPORT env and try to use -p 5555 pg_dumpall ask if there
is
postmaster listen on port 5432.

thanks in advice

regards

R. Partyka

BTW. Sorry if this was already noticed on list.


Re: an error while pg_dumpall

From
Tom Lane
Date:
"Partyka Robert" <bobson@saturn.alpha.pl> writes:
> getInherits(): SELECT failed.  Explanation from backend: 'ERROR:
> Attribute 'inhrel' not found

IIRC, this is the symptom you get when trying to run a 6.5 pg_dump
against a 7.0 database ... or was it the other way around?  Anyway,
check your PATH to see which pg_dump you're invoking.

            regards, tom lane