Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore

"Andrus Moor" <eetasoft@online.ee> writes:
>> No, this is just pilot error.  Any version of pg_dump will produce
>> output that is meant to be loaded into the matching server version
>> (or a later version).  If you are intending to load back into 8.4,
>> use the 8.4 pg_dump.

> Windows application needs to support backup/restore for all servers >=8
> between same server version.

Why does it have that requirement?  And why doesn't it use the pg_dump
that came with the server?  It seems pretty lame to assume that your app
has to provide pg_dump and not any other part of the Postgres
installation.

            regards, tom lane