pg_dump problems

Started by Michelle Murrainover 25 years ago2 messagesgeneral
Jump to latest
#1Michelle Murrain
mpm@norwottuck.com

In doing a pg_dump on a relatively new Postgres install, I get an
error I've never seen before:

getInherits():SELECT failed. Explanation from backend:
'ERROR:Attribute 'inhre1' not found.'

The dump didn't work. In verbose mode, it happens when it is reading
table inheritance information.

It's a pretty simple database, only a few tables. It will be a little
bit of a pain to recreate, but not devastating. However, this install
is on my laptop, where I do a lot of my development work. I'd like to
make sure I have a reliable way of getting my databases from there to
the server.

Thanks.

Oh - Linux-Mandrake 7.0, Postgres 7.0

Michelle
-------------------------------------------
Michelle Murrain, Ph.D.
President, Norwottuck Technology Resources
mpm@norwottuck.com www.norwottuck.com

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Michelle Murrain (#1)
Re: pg_dump problems

Michelle Murrain <mpm@norwottuck.com> writes:

In doing a pg_dump on a relatively new Postgres install, I get an
error I've never seen before:

getInherits():SELECT failed. Explanation from backend:
'ERROR:Attribute 'inhre1' not found.'

IIRC, that's what you get when you run a 6.5 pg_dump against a 7.0
server. Check your PATH...

(Yes, there's a version check in pg_dump now, but there wasn't
then :-()

regards, tom lane