Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore - Mailing list pgsql-general

From Andrus Moor
Subject Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore
Date
Msg-id 12EBBE44C0234BF4A06DECDBC929EDCA@andrusnotebook
Whole thread Raw
In response to Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
> 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.
>
> You may have been reading the recommendation to use the later version's
> pg_dump when dumping an older server to perform an upgrade.  It's good
> advice, but only for upgrades.

Windows application needs to support backup/restore for all servers >=8
between same server version.
So it must distibute 8.0, 8.1, 8.2, 8.3, 8.4, 9.0  pg_dump/pg_restore with
application,
including all VC++ runtime versions and all dlls specific to this version
and invoke
specific pg_dump/pg_restore depending on server version ?

Do you really think that this is reasonable ?
I'nt there a simpler way ?

I havent seen that pg_admin includes every pg_dump / pg_restore version.

Andrus.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore
Next
From: Tom Lane
Date:
Subject: Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore