From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8
Date: Fri, 18 Jan 2019 17:36:39 +0200
Message-ID: <cec2b6b2-3f41-41b8-1896-b819c131d142@matrix.gatewaynet.com> (raw)
In-Reply-To: <201901181530.42190.gary.stainburn@ringways.co.uk>
References: <201901181429.51278.gary.stainburn@ringways.co.uk>
<201901181508.26233.gary.stainburn@ringways.co.uk>
<8c6bfd45-8aa5-b966-ce29-ac65b7b525b3@matrix.gatewaynet.com>
<201901181530.42190.gary.stainburn@ringways.co.uk>
On 18/1/19 5:30 μ.μ., Gary Stainburn wrote:
> 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?
That should work as well. The other way around is impossible.
>
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: achill@matrix.gatewaynet.com, pgsql-admin@lists.postgresql.org
Subject: Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8
In-Reply-To: <cec2b6b2-3f41-41b8-1896-b819c131d142@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox