Re: upgrade path from PG 8.3 to PG 9.5

On 22/03/2017 16:47, Keith wrote:
>
> We used pg_upgrade recently for migrating from 8.3 -> *9.4 (the last version which supports 8.3)*, and it went nice. We had some custom functions in C, and pg_upgrade is a disciplined way to deal
> with the migration
>
> I would be curious how that worked since the documentation states the old version must be at least 8.4.7 for pg_upgrade to work.

You missed the 9.4 part : https://www.postgresql.org/docs/9.4/static/pgupgrade.html
"pg_upgrade supports upgrades from 8.3.X and later"

Then they can pg_upgrade from 9.4 -> 9.6 much easier.

>
> https://www.postgresql.org/docs/9.6/static/pgupgrade.html <https://www.postgresql.org/docs/9.6/static/pgupgrade.html>
>
> Just checked this with 8.3.22 and confirmed the binary won't even let you run it.
>
> $ pg_upgrade -b /opt/pgsql8323/bin -B /opt/pgsql962/bin -c -d /opt/pgdata/83 -D /opt/pgdata/83upgrade
> Performing Consistency Checks
> -----------------------------
> Checking cluster versions
> This utility can only upgrade from PostgreSQL version 8.4 and later.
> Failure, exiting
>
> Not trying to be pedantic, but don't want to lead someone down a road that won't work properly.
>
> Keith--
> Achilleas Mantzios
> IT DEV Lead
> IT DEPT
> Dynacom Tankers Mgmt
>
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org <mailto:pgsql-admin(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin <http://www.postgresql.org/mailpref/pgsql-admin>
>

--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt