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 1h1s6c-0002Wq-Bj for pgsql-admin@arkaria.postgresql.org; Thu, 07 Mar 2019 12:26:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h1s6b-0004bR-3S for pgsql-admin@arkaria.postgresql.org; Thu, 07 Mar 2019 12:26:33 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h1s6a-0004bJ-OK for pgsql-admin@lists.postgresql.org; Thu, 07 Mar 2019 12:26:32 +0000 Received: from hermes.gatewaynet.com ([193.92.121.98]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h1s6W-0001MD-QP for pgsql-admin@lists.postgresql.org; Thu, 07 Mar 2019 12:26:31 +0000 Received: from smadev.internal.net (pc131.internal.net [10.9.200.131]) by hermes.gatewaynet.com (8.15.2/8.15.2/Debian-8) with ESMTPS id x27CQJgf018797 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT) for ; Thu, 7 Mar 2019 14:26:24 +0200 Received: from smadev.internal.net (smadev [10.9.200.131]) by smadev.internal.net (8.15.2/8.15.2) with ESMTP id x27CQJqi080886 for ; Thu, 7 Mar 2019 14:26:19 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Subject: Re: Pgupgrade is best? To: pgsql-admin@lists.postgresql.org References: From: Achilleas Mantzios Message-ID: Date: Thu, 7 Mar 2019 14:26:19 +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: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US X-Virus-Scanned: clamav-milter 0.100.2 at hermes X-Virus-Status: Clean X-Spam-Status: No, score=-25.0 required=5.0 tests=ALL_TRUSTED,DYN_HAM_COORD, DYN_HAM_IT,DYN_HAM_NAUTICAL,DYN_HAM_SIGNAT1,DYN_SPAM_SUBJ autolearn=unavailable autolearn_force=no version=3.4.2 X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on hermes.gatewaynet.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 7/3/19 1:40 μ.μ., still Learner wrote: > Hi There, > > Planning to upgrade a double digit TB sized DB from PG 9.4 to 11.1. what is the best way ? Logical or pgupgrade with -k ? Or any other plz suggest. Tried slony but didn't help much in poc. We upgraded ours from 9.3 -> 10 in summer 2018, with quite a lot of custom code, functions, extensions and it went absolutely fine, we were able to have the server up in some minutes. However, you should EXTREMELY test everything before the final upgrade, and I dont mean only the actual app (and all kinds of db related code, queries, data sources, drivers, etc),  but the actual pg_upgrade as well. You don't wanna be left compiling and upgrading some extension during the upgrade phase. All should be tested and documented (I wouldn't say automated but you get the point) beforehand. > > Thanks in advance. > > Regards. -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt