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 1tLTlo-00F30t-Hj for pgsql-general@arkaria.postgresql.org; Wed, 11 Dec 2024 20:57:20 +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 1tLTlm-002Ys7-0G for pgsql-general@arkaria.postgresql.org; Wed, 11 Dec 2024 20:57:19 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tLTll-002Yqx-D6 for pgsql-general@lists.postgresql.org; Wed, 11 Dec 2024 20:57:18 +0000 Received: from fout-b6-smtp.messagingengine.com ([202.12.124.149]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tLTlj-002KJZ-Vf for pgsql-general@postgresql.org; Wed, 11 Dec 2024 20:57:17 +0000 Received: from phl-compute-06.internal (phl-compute-06.phl.internal [10.202.2.46]) by mailfout.stl.internal (Postfix) with ESMTP id AD150114010E; Wed, 11 Dec 2024 15:57:14 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-06.internal (MEProxy); Wed, 11 Dec 2024 15:57:14 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= 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=1733950634; x=1734037034; bh=2ddAMXFV8UtSTjus2FPEA6cmGHqLxmUHHVnGpHV9s1s=; b= TgO1ZezJ8i13QLeaobXZmbrnrWM4dd9HJ//MY/WSXb5qlzJbTIOikycpbC4bn9et yD81Nmg0AgOQBlZRC0HGRwEASbSG5vt/B5pyhN9zwyAQQKJK4RM3L371fYwCD8KM A0iQFaKnW1QtFOsU2U2fSNsON3itDDVJkzSaqLr3WdrPGv9pQRL92KPIQJnGx48O OGA/Gucj2s1eimg94LVbOzckAohEUwy7nKQ8i5Nb0tuxhqHSGvl9o9R/0XxksGJ2 kaMVLFfU2TJx6XS4PNwrV+I8KGwl4gHYDuuc6eR1A9YVUEfiCgwyeO5txaxGVFGG sEzTeym9t35X/3merrdOZg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=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-sender :x-me-sender:x-sasl-enc; s=fm1; t=1733950634; x=1734037034; bh=2 ddAMXFV8UtSTjus2FPEA6cmGHqLxmUHHVnGpHV9s1s=; b=RNUGHQAHXSpg3elpn bytxsfSe2jZvNhJAV4eQ4VeGtlkUUUUYsM0iX0C9GSxNOY45IZLY4XSb0FtWjVQZ mtnU1CFPVFn533OUS8Otvwy9Ki5GlkLmsaFKk4v+OlJ4SXFkc2y9MX66ODOUX6oq GAOdO+LTC84yLnW9eNBCkY/8eOlkzEw/4m3C/u8v2PQK67ZuaGcUeb1pLXKte6jy wBtGat2zJNQniOOhYX6Vhaoi0UiBUVlUtKBh3iu9iJK71elj1LMIh/IUOZBuqZu2 +FuKrM1eYuJdHqvARI7JxsM6sb9g1710g2I/1H27IkOUT29Hox9v8Wu2OxZuJVVp rc3RQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrkedtgddugedvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnecujfgurhepkfffgggfuffvfhfhjggtgfesthekredttddvjeen ucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrse grkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpeelgeevkeekkeeuiefgtdev ieeluefhfedufeetkeejffekjeeujeehgeehgeektdenucffohhmrghinhepphhoshhtgh hrvghsqhhlrdhorhhgnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghi lhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomhdpnhgspg hrtghpthhtohepfedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepvghsthgvvghm sghsvhdqfhhorhhumheshigrhhhoohdrtghomhdprhgtphhtthhopehrohhnlhhjohhhnh hsohhnjhhrsehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqghgvnhgvrhgr lhesphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 11 Dec 2024 15:57:13 -0500 (EST) Message-ID: <037a8338-3434-47d4-aaad-ef186d4d3250@aklaver.com> Date: Wed, 11 Dec 2024 12:57:13 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X To: Bharani SV-forum , Ron Johnson , pgsql-general References: <0558ddd4d71641bdb41fa49b2425f73c@safrangroup.com> <98965993.3138805.1731699978332@mail.yahoo.com> <564950518.5117550.1733177884387@mail.yahoo.com> <07ab2d83-ffe5-4bec-9626-22a68f732579@aklaver.com> <273a88dc-4134-47d5-bc19-30ff5f97926c@aklaver.com> <498dfb34-4dd7-4f48-8188-355e1488d7e6@aklaver.com> <1061066336.5835157.1733316137292@mail.yahoo.com> <1918413683.2239751.1733944364448@mail.yahoo.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: <1918413683.2239751.1733944364448@mail.yahoo.com> 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 12/11/24 11:12, Bharani SV-forum wrote: > Team > As suggested from old server, post shutdown of DB, I did OS level dump > of PG_DATA folder and had restored in the new server. If you follow the process shown here: https://www.postgresql.org/message-id/CAKAnmmKZdhnhdNRd3OgDyEco9OPkT%3DqA_TeWMFMRvUM9pXauKg%40mail.gmail.com You would not have to do the below. > > Any idea on how to install the older binary postgres 13.18 ( OS=Amazon > Linux 2023.6.20241121) under a dedicated folder suffixed as the > following e.g.) /usr/pgsql1318 > > System Admin had already installed newer version pgsql 15.08 binaries in > the  new server (OS= Amazon Linux 2023.6.20241121) in the folder "/usr/bin/" > > We were quoted , OS = Amazon Linux 2023.6.20241121 doesnot support > postgres ver 15.10 (Community edition) under its AWS-EC2. That does not reflect well on Amazon Linux, that it is missing two critical bug releases. > > Regards > > > -- Adrian Klaver adrian.klaver@aklaver.com