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 1tIEr7-00D7sz-3M for pgsql-general@arkaria.postgresql.org; Mon, 02 Dec 2024 22:25:25 +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 1tIEr4-0049KO-Fk for pgsql-general@arkaria.postgresql.org; Mon, 02 Dec 2024 22:25:23 +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 1tIEr3-0049KG-K7 for pgsql-general@lists.postgresql.org; Mon, 02 Dec 2024 22:25:23 +0000 Received: from fhigh-b4-smtp.messagingengine.com ([202.12.124.155]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tIEr0-000j06-QY for pgsql-general@postgresql.org; Mon, 02 Dec 2024 22:25:22 +0000 Received: from phl-compute-08.internal (phl-compute-08.phl.internal [10.202.2.48]) by mailfhigh.stl.internal (Postfix) with ESMTP id 6EF4B25401D8; Mon, 2 Dec 2024 17:25:16 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-08.internal (MEProxy); Mon, 02 Dec 2024 17:25:16 -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=1733178316; x=1733264716; bh=a4uQFnYE/Gi0HeJp/oVZL9izBAP3qdedKIOWBLA5aKM=; b= UQKfNI0XlJD4PF4/MApwR3ILEqETXd5Kpx9CPlQ2gpAs3Z+4cbbvR+GmehfKnsWB 8w2cS6q59t3jJhUJ7OH1ziQGTZYAycYMowGJJjlKeLI9OKY+eoxzeXvifJEnbK4q ZLVB4eIBlX1dVaIXZyRqUCJ2gR55dgwuL9BXwkldr6zUPV/SWGyX94Cy/Peoy+bC WoqgtgR+1g1ve88WXnf6bmbj9LZNcvfg6VGZ1YlLvKQPdBMOwbv009XD1UnJe2CP N3dJwL878yhS205lcIenGsCiGvxT65HUYxc1TO1Y7+HW8eIckOWufM9VrejKb+xX ujvg4bPR5XWwp569pjvLJg== 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=1733178316; x=1733264716; bh=a 4uQFnYE/Gi0HeJp/oVZL9izBAP3qdedKIOWBLA5aKM=; b=0q+PHfL7H1Gm5tacg E3ar2ZqHWr/HIUfNqwpl0Em+qmWToB85f60Vcmt/wX7w8E1pFoxPN5WGIltJTVcy b1gBAawc2/e7kkEL9A+kcNe7ynbXTllxmtcGcyjHqbqsPt5AXFySr0map8ZFXUC3 VGiiFxuga9HdVxPYqeG711l70MSZ30vJHEOLKCLW/bXkfmz3SQQ4vhOOg91i3UpC fdvs1/+fC7+qpcnqMqvF0uw2BfIGHGj2M7QsmjrCGM/COiFZyavzZgXNS/14iPbq Y8z9FEweTcnL+Wg3VA7xgU6oTwgcbH+WhbPja1TDt8yosSc0PzSAptTZhxrfUjpF cjE4A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrheelgdduheelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnecujfgurhepkfffgggfuffvfhfhjggtgfesthekredttddvjeen ucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrse grkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpeelgeevkeekkeeuiefgtdev ieeluefhfedufeetkeejffekjeeujeehgeehgeektdenucffohhmrghinhepphhoshhtgh hrvghsqhhlrdhorhhgnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghi lhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomhdpnhgspg hrtghpthhtohepvddpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepvghsthgvvghm sghsvhdqfhhorhhumheshigrhhhoohdrtghomhdprhgtphhtthhopehpghhsqhhlqdhgvg hnvghrrghlsehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 2 Dec 2024 17:25:15 -0500 (EST) Message-ID: <08e1585f-8ab7-445d-980f-48ad53fa1efc@aklaver.com> Date: Mon, 2 Dec 2024 14:25:14 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X To: Bharani SV-forum , "pgsql-general@postgresql.org" References: <0558ddd4d71641bdb41fa49b2425f73c@safrangroup.com> <98965993.3138805.1731699978332@mail.yahoo.com> <564950518.5117550.1733177884387@mail.yahoo.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: <564950518.5117550.1733177884387@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/2/24 14:18, Bharani SV-forum wrote: > Team > Pl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver > 15.X > > Env = EC2 based Community PostgreSQL Ver 13.16.2 > > we will be performing upgrade of our EC2 server too along with new OS. > > Need help in vetting my steps for Postgres DB upgrade from Ver 13.X to > ver 15.X > *ASIS-existing server = EC2 with Community PostgreSQL Ver 13.16.2* > - ensure to capture all the pre.req meant for ver 15.10 are being met. > - shutdown db. > - take offline full backup (PG_DATA folder alone)  using OS command > > *Proposed-new EC2 server (with new Operating System version along > Postgres Ver 15.10 Binaries)* > - install postgres 15.10 binaries > - ensure to DISABLE auto startup and shutdown of postgres 15.10 > -  Restore offline full backup (PG_DATA folder alone) using OS command > -  start performing pg_upgrade step to upgrade postgres from ver 13.16.2 This is not going to work, you need to have Postgres 13 installed also. It all laid out here: https://www.postgresql.org/docs/15/pgupgrade.html In Usage section. > to 15.10 > > please guide me, if i have missed any steps in the abovesaid process > > To start new DB features, planning to rollout out the following > feature's alone > a) TLE extension for password compliance > b) parallelize vacuum jobs to utilize -j option > -- Adrian Klaver adrian.klaver@aklaver.com