Re: 7.2b3 pg_dump, general 7.2b3 comments

Joe Conway <joseph(dot)conway(at)home(dot)com> writes:
> Is pg_dump supposed to work against prior version databases? I was
> moving data from an old server (running 7.2devel from several months
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> ago) to a new server (running 7.2b3), using pg_dump on the *new* server,
> and got the following message:

> # pg_dump -h 172.16.1.84 -U postgres -t el_names -i lt_lcat > el_names.dmp
> Password: <types in password>
> pg_dump: query to obtain list of tables failed: ERROR: Attribute
> 'relhasoids' not found

Oh, never mind: I see it. pg_dump's test is on whether the server calls
itself 7.2 or not. You've evidently got a copy from back before the
changes to make OIDs optional. The versioning code is not set up to
deal with intermediate development versions, so it gets it wrong about
what query to use. You'll need to use the pg_dump of the same vintage
as the 7.2devel server.

You're a brave man to be putting production data on CVS-tip servers.
I wouldn't recommend it ;-)

regards, tom lane