Thread: an error while pg_dumpall
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.
"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