Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gkWCP-00061S-Rm for pgsql-admin@arkaria.postgresql.org; Fri, 18 Jan 2019 15:36:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gkWCO-0002V9-FO for pgsql-admin@arkaria.postgresql.org; Fri, 18 Jan 2019 15:36:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gkWCO-0002V2-7r for pgsql-admin@lists.postgresql.org; Fri, 18 Jan 2019 15:36:48 +0000 Received: from hermes.gatewaynet.com ([193.92.121.98]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gkWCL-00031W-Rk for pgsql-admin@lists.postgresql.org; Fri, 18 Jan 2019 15:36:47 +0000 Received: from smadev.internal.net (pc131.internal.net [10.9.200.131]) by hermes.gatewaynet.com (8.14.3/8.14.3/Debian-9.4) with ESMTP id x0IFad0f005152 for ; Fri, 18 Jan 2019 17:36:44 +0200 Received: from smadev.internal.net (smadev [10.9.200.131]) by smadev.internal.net (8.15.2/8.15.2) with ESMTP id x0IFadiU090071 for ; Fri, 18 Jan 2019 17:36:39 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Subject: Re: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8 To: pgsql-admin@lists.postgresql.org 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> From: Achilleas Mantzios Message-ID: Date: Fri, 18 Jan 2019 17:36:39 +0200 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:60.0) Gecko/20100101 Thunderbird/60.3.2 MIME-Version: 1.0 In-Reply-To: <201901181530.42190.gary.stainburn@ringways.co.uk> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US X-Virus-Scanned: clamav-milter 0.98.7 at hermes X-Virus-Status: Clean X-Spam-Status: No, score=-29.0 required=5.0 tests=ALL_TRUSTED,DYN_HAM_COORD, DYN_HAM_IT,DYN_HAM_NAUTICAL autolearn=unavailable version=3.3.1 X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on hermes.gatewaynet.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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