On Fri, Jul 15, 2016 at 4:13 PM, Melvin Davidson <melvin6...@gmail.com> 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
