Re: migrating data from an old postgres version

On Fri, Jul 15, 2016 at 4:02 PM, Paul Ramsey <pramsey(at)cleverelephant(dot)ca>
wrote:

> Make sure to pg_dump -Fc
> (note the flags)
> so that in case you need to do a hard restore (if you’re going from
> postgis 1.x to 2.x) you can run the dump file through the special cleaning
> script.
>
> See postgis documentation notes on “hard upgrade” for full info on doing a
> clean 1->2 upgrade.
>
> If he’s already blown away his old environment then yeah, you’re going to
> have to exactly duplicate it first so you can run 8.4 *and* an old version
> of postgis (have to match major version numbers) and get a clean dump file
> out of it.
>
> P.
>

Yeah, that perl script really works well, used it a lot.
Only downside is the downtime you need for it, on servers that is.
I really like pg_upgrade, and i have been able to use that since
apt.postgresql.org offers several versions per distro, and includes postgis
too.
Great stuff, upgrade a big db in single minutes of downtime.

--
Willy-Bas Loos