From: | Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8 |
Date: | 2019-01-18 15:30:42 |
Message-ID: | 201901181530.42190.gary.stainburn@ringways.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Friday 18 January 2019 15:18:45 Achilleas Mantzios wrote:
> On 18/1/19 5:08 μ.μ., Gary Stainburn wrote:
> > If I were to go to 10.x on Centos 7, would I be able to install it
> > alongside the existing 9.6 to test it? I have noticed with the 9.6
> > install that it's now using the version number as part of the data path.
>
> 9.6 is not page level compatible with e.g. 9.5 whereas 10.6 is with 10.5.
> So in the versioning scheme PostreSQL community just dropped one dot.
> Before (<=9*) it was x.y.z with all x.y.* being compatible whereas now
> (>=10*) it is x.y with all x.* being compatible. By compatible we mean that
> no pg_dump/restore or pg_upgrade is needed, just recompile and install.
I have installed 10.6, configured it and imported the data all without issue.
So far, so good.
I have done the import using the pg_dumpall done on the 8.3 system. From the
comments earlier, would I be better off doing a pg_dumpall of the 8.3 system
using the binarys from the 10.6 system?
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleas Mantzios | 2019-01-18 15:36:39 | Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8 |
Previous Message | Achilleas Mantzios | 2019-01-18 15:18:45 | Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8 |