On Fri, Jul 15, 2016 at 4:13 PM, Melvin Davidson <melvin6925@xxxxxxxxx> wrote:
If you dump with -F p (plain is default) then the version does not matter.That is the recommended method for upgrading from older versions.
https://www.postgresql.org/docs/9.4/static/upgrading.html
Problem is that we use postgis and the versions differ between the postgres installations.
So we have to upgrade postgis in the process.
We use a perl script for that, which gets a list of the objects in the backup and then filters what will be restored. But for that it needs a custom dump, hence Paul Ramsey's advice.
--
Willy-Bas Loos
