Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ridjM-000jmH-GM for pgsql-general@arkaria.postgresql.org; Fri, 08 Mar 2024 17:10:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ridjL-00EZ3O-09 for pgsql-general@arkaria.postgresql.org; Fri, 08 Mar 2024 17:09:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ridjK-00EZ3G-0I for pgsql-general@lists.postgresql.org; Fri, 08 Mar 2024 17:09:59 +0000 Received: from fout2-smtp.messagingengine.com ([103.168.172.145]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ridjG-003T8E-NM for pgsql-general@lists.postgresql.org; Fri, 08 Mar 2024 17:09:57 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailfout.nyi.internal (Postfix) with ESMTP id 60B1013800E1; Fri, 8 Mar 2024 12:09:53 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Fri, 08 Mar 2024 12:09:53 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1709917793; x=1710004193; bh=qYDSwiFuIq6hMEohUFsoy4ty1rj2hXSjAXWZjGAbvw0=; b= Xudh8MpPTmd0B3S7iSURXBwgzykrorzDLUgiSJtxcmOlU5L2dDTAyco6NjUaKvNF Ndp85F4PchJj9xcC6jskz1sy+WgzixpzC6ybxHMW6Tc560tRfzz9mw4vmf4YO0nX n9ptr61uy3fsllvoS8nZ2n8IxjIu9IeLdX9YJv0o3H5JyPDQ88EaWx9++f+UaCcs hGknnFAcd5cL+1v/2S1f2tWXUS+DZWSrWsnOOlKX3M/5h+rGhARgY+nZAI/Hw6fx oKsfIQ1JBQR7IOU7DJoZZFNsz6HbNXR6Xjig5mDY3GYofswFFzJGYE/dELJWiA+j AapVuai35TMhn4xx0a8spQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1709917793; x= 1710004193; bh=qYDSwiFuIq6hMEohUFsoy4ty1rj2hXSjAXWZjGAbvw0=; b=b hCASBVBOJqf+kz77s61d5Y2VQUwO0TlcvJRgNch/mf5n5mIIb1vTmR5kfdDbPV/D +WA4z15fPLSmcijom2uatbARiE+wbwl258R1rubsfT5IuSE5ttV7w70OXaSN1jey Zgb96AXhV9tiVUcx6mqLMxnJf5VuQnxs94UBTijR36g/XptygjtLikd9PvN4JPVa 2WKNW7DsAZ3Uv2Sr5qcucPw82mBP62PDr2eEoSaOLvdgE93py0buXzVhLKqRvp+E 9Z7+63dR4wXpIrSghk/tdL76lTYeRY8Eqtp9zQiC19D1VMfcuzngUPhF2W39Qc3d 5Hdt+Idzg78U6rfzSzUnQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrieehgdeliecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefkffggfgfuvfevfhfhjggtgfesthekredttddvjeenucfhrhhomheptegurhhi rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh hmqeenucggtffrrghtthgvrhhnpeejkeegtefhfeegheehkedukefhfeeihfetkedukedt tdeiveejkeelheehtdetffenucffohhmrghinheprghmrgiiohhnrdgtohhmnecuvehluh hsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhk lhgrvhgvrhesrghklhgrvhgvrhdrtghomh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 8 Mar 2024 12:09:52 -0500 (EST) Message-ID: <3957140e-1921-472e-a346-8cf4fee078e1@aklaver.com> Date: Fri, 8 Mar 2024 09:09:52 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: v11.5- v15.3 upgrade (linux) Content-Language: en-US To: David Gauthier , Yogesh Sharma Cc: pgsql-general@lists.postgresql.org References: <88132f81-7e82-4d53-a55a-eede564351da@catprosystems.com> From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 3/8/24 08:57, David Gauthier wrote: > Thanks for the reply. > > When you say "dump/restore" do you mean pg_dump then running the > resulting SQL into the destination DB? > I like the replication option myself best (min downtime), especially as > we use a DB alias for connections.  But I don't think I'll be able to > sell that to the IT group. You said the dump/restore has been tested. How long did that take? > > Regarding the safety of running a "drop extension plperlu cascade" on > the v11.5, would you consider that to be safe GIVEN that there are no > plperlu procs that it will affect?  I need to be able to tell IT that > I'm not the only one who thinks that it's safe. BEGIN; DROP LANGUAGE plperlu; ROLLBACK; See if the above complains about anything depending on it. If not: DROP EXTENSION plperlu; > > > > On Fri, Mar 8, 2024 at 11:28 AM Yogesh Sharma > > wrote: > > Greetings, > > On 3/6/24 19:19, David Gauthier wrote: > > Hi: > > I'm a PG user in a big corp with an IT dept that administers a PG > > server/instance that I use.  It's an old install, v11.5, and we need > > to upgrade to v15.3.  They want to bring the upgraded DB up on a new > > linux vm which has OS upgrades of its own.  So it's a move AND an > > upgrade. There are 2 concerns.... > > > > First has to do with a jump from 11.5 - 15.3 ?  Is it safe to do > this > > given so many major intermediate versions being skipped ? > > Generally speaking, it is safe from database point of view but you have > to verify that application is working as expected with PostgreSQL 15, > driver update, any query performance issues, any deprecate features in > use, collation differences, and performance verification, etc. > > PostgreSQL supports dump/restore (slow and longer downtime), binary > upgrade using pg_upgrade (faster and low downtime), and logical > replication (complex and least downtime). Since OS upgrade is also part > of the equation, dump/restore or logical  are better candidates. Due to > OS collation difference I would avoid binary upgrade path. > > > -- > Kind Regards, > Yogesh Sharma > PostgreSQL, Linux, and Networking Expert > Open Source Enthusiast and Advocate > PostgreSQL Contributors Team @ RDS Open Source Databases > Amazon Web Services: https://aws.amazon.com > -- Adrian Klaver adrian.klaver@aklaver.com