Re: upgrade path from PG 8.3 to PG 9.5

On Wed, Mar 22, 2017 at 11:08 AM, Achilleas Mantzios <
achill(at)matrix(dot)gatewaynet(dot)com> wrote:

> 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.
>
>
Ahh I missed that note in the 9.4 docs. Thanks for clarification.

>
> 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>
> pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>
>
> --
> Achilleas Mantzios
> IT DEV Lead
> IT DEPT
> Dynacom Tankers Mgmt
>
>