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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1tNUj4-0007GJ-O3
	for pgsql-admin@arkaria.postgresql.org; Tue, 17 Dec 2024 10:22:51 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1tNUi4-000QeR-Jz
	for pgsql-admin@arkaria.postgresql.org; Tue, 17 Dec 2024 10:21:48 +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 <jnarendran3@gmail.com>)
	id 1tNUi4-000QeD-6W
	for pgsql-admin@lists.postgresql.org; Tue, 17 Dec 2024 10:21:47 +0000
Received: from mail-wm1-x32f.google.com ([2a00:1450:4864:20::32f])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <jnarendran3@gmail.com>)
	id 1tNUi1-00088C-7y
	for pgsql-admin@lists.postgresql.org; Tue, 17 Dec 2024 10:21:47 +0000
Received: by mail-wm1-x32f.google.com with SMTP id
 5b1f17b1804b1-4362bae4d7dso28128305e9.1
        for <pgsql-admin@lists.postgresql.org>;
 Tue, 17 Dec 2024 02:21:45 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1734430904; x=1735035704;
 darn=lists.postgresql.org;
        h=to:subject:message-id:date:from:mime-version:from:to:cc:subject
         :date:message-id:reply-to;
        bh=Wx328uLqsXaZyfbMZZxAPuCZJg2rMG8L22ZKZtuSIiw=;
        b=eLiWDVGCv0AM1ipxvG41HUZ3/HCiJcQrnFH/S9ILY9qzLFj613viJ9Fnklw5NNYf46
         jSViL/ke77DtizClkhzEmSq9EtSW3a0WJ9bQtwkPIbwuHPPSZ9r8I2jS+x74YZ74QTA2
         l5bO2CasMTFj2sbgIn23Atwbnkm6bKdugsHPhc1JP2GBnB9J42T6e5uKe75Lp57x97gX
         Vthymw4RU8rU0Wzec/YCB2QGpLx+KQGCX5DuOSS8FWyz3sHx1EaIUfIkf6QY7Hp91x5Y
         MLjx0wM/uGO5NnrkZ6xwoikWS+SDQSuQV0pJuzJCiYsiJbsCFNLp7Eg44jXmA11fWD4k
         qtwg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1734430904; x=1735035704;
        h=to:subject:message-id:date:from:mime-version:x-gm-message-state
         :from:to:cc:subject:date:message-id:reply-to;
        bh=Wx328uLqsXaZyfbMZZxAPuCZJg2rMG8L22ZKZtuSIiw=;
        b=cx0krgahtsFRhDHeGna65UfpVrDswP7k7JD1QYWDzCJ8iHT6fnRPGhGN752srkkAOr
         WsmPZzqZf+r38kHSv9RDZ74HbQaDIDxGtMHeDmNvunJiLDTp4YYs03WU4pzMsbPDCiyq
         nDc+cxV87CldxUoMVbH2E3SE7UfrioQQwHCuTJv2q3oJWRxCkWStFXWB9GX2U2jCQtNp
         6JI7uDnx93YWZZsYK6Z3J6FfOBy153td4n4bus5QPMFxWeybYfEPYuuuRmQCK5A9pa1H
         llCR9L41oRvfuYjwQD8J45Mdm1Y+gfrWBC3XeuarEcuByxRrNsoTcbi8LJEErjE/KE9O
         TBrA==
X-Gm-Message-State: AOJu0Yz2gvt8s8lEwgHKkRs4x5BRF575lLYtP7Zm94b9UIfAoBIqPHnS
	jkJtwPNEh8w77i83rl8ZF001NVARXxQNsWFnNHaow9yTco83+Kf+LgSGuRUwjzTmGhZ6YLCMT7J
	MdZEG3RPjqfyHLOi5ecZZHnMzsVFvys0h
X-Gm-Gg: ASbGncvcjonkMLWVHaUoz8qOEP54kpB10wpFeZA4mhbivBdO5g0yL20FdxdZN/VXmrw
	UfkOFv7nRZ/zkUQBX/VnUvmPFZBl1aYGVJZmVEGpvCO9z9w0A7Nbaq6c=
X-Google-Smtp-Source: 
 AGHT+IG07v/PIWPWy0l05vfAjwd+0uecNS/Ux1hGJdnaEYX/YbzpiF251uN9M6kd1ecpqs9Q3oQ6ZOLyfplx4POA/ns=
X-Received: by 2002:a05:600c:3491:b0:435:b064:7dce with SMTP id
 5b1f17b1804b1-4362aa66f9fmr158166845e9.18.1734430903521; Tue, 17 Dec 2024
 02:21:43 -0800 (PST)
MIME-Version: 1.0
From: "Narendran .j" <jnarendran3@gmail.com>
Date: Tue, 17 Dec 2024 15:51:31 +0530
Message-ID: 
 <CA+-Cqf4EoAxwfqvUQiPU--zJ2Qt+wA3239XWE13gKD+PGqZa+Q@mail.gmail.com>
Subject: Postgres upgradation
To: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e458dc062974a93b"
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2B-Cqf4EoAxwfqvUQiPU--zJ2Qt%2BwA3239XWE13gKD%2BPGqZa%2BQ%40mail.gmail.com>
Precedence: bulk

--000000000000e458dc062974a93b
Content-Type: text/plain; charset="UTF-8"

Hello All,

In our environment, PostgreSQL is currently running on lower versions,
ranging from 9 to 11. We are planning to upgrade to the latest version, and
I have a few questions regarding the process.

What are the key considerations or checks we need to perform before the
upgrade?

Can we directly upgrade from version 9 to 15, or is a step-by-step upgrade
required?

How should we handle extensions during the upgrade process?

What challenges or issues should we anticipate during or after the upgrade?

If anyone with experience in upgrading Postgres, please share your guidance.

Regards,
Naren

--000000000000e458dc062974a93b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Hello All,<div dir=3D"auto"><br></div><div dir=3D"auto">I=
n our environment, PostgreSQL is currently running on lower versions, rangi=
ng from 9 to 11. We are planning to upgrade to the latest version, and I ha=
ve a few questions regarding the process.</div><div dir=3D"auto"><br></div>=
<div dir=3D"auto">What are the key considerations or checks we need to perf=
orm before the upgrade?</div><div dir=3D"auto"><br></div><div dir=3D"auto">=
Can we directly upgrade from version 9 to 15, or is a step-by-step upgrade =
required?</div><div dir=3D"auto"><br></div><div dir=3D"auto">How should we =
handle extensions during the upgrade process?</div><div dir=3D"auto"><br></=
div><div dir=3D"auto">What challenges or issues should we anticipate during=
 or after the upgrade?</div><div dir=3D"auto"><br></div><div dir=3D"auto">I=
f anyone with experience in upgrading Postgres, please share your guidance.=
</div><div dir=3D"auto"><br></div><div dir=3D"auto">Regards,</div><div dir=
=3D"auto">Naren</div></div>

--000000000000e458dc062974a93b--