old postgres

Martijn van Oosterhout kleptog at svana.org
Wed May 1 18:29:19 EST 2002

On Wed, May 01, 2002 at 05:39:11PM +1000, adrian wrote:
> I have upgraded my linux and applications and in the process postgres 
> was upgraded from 6.5.* to 7.1 This is a problem  I now need an OLD 
> version of pg_dumpall. Can someone help?

Hmm, you mean that your database is in 6.5 format but the server is 7.1?
This is bad as the server does not understand older (or newer) formats.
Since pg_dumpall uses the postmaster, it cannot help you here. The only real
solution is to temporarily downgrade the server, pg_dumpall and upgrade
again. What distribution is this?

I'm not sure if pg_upgrade will work in this case.

OTOH, if you have the schema lying around you may be able to use my dumper
program to grab just the data. It's not perfect (several features not
supported) but it might help. Find it at:


I showed it to the postgresql developers but didn't get any response. Let me
know if you try it out.
Martijn van Oosterhout   <kleptog at svana.org>   http://svana.org/kleptog/
> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America

More information about the linux mailing list