Re: upgrade path from PG 8.3 to PG 9.5

[Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx>]

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

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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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