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 1sLI3X-00EFcB-2b for pgsql-general@arkaria.postgresql.org; Sun, 23 Jun 2024 07:54:35 +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 1sLI3T-006nxZ-BJ for pgsql-general@arkaria.postgresql.org; Sun, 23 Jun 2024 07:54:31 +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 1sLI3T-006nxR-0P for pgsql-general@lists.postgresql.org; Sun, 23 Jun 2024 07:54:31 +0000 Received: from mail-lf1-x12b.google.com ([2a00:1450:4864:20::12b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sLI3Q-0036op-TJ for pgsql-general@lists.postgresql.org; Sun, 23 Jun 2024 07:54:30 +0000 Received: by mail-lf1-x12b.google.com with SMTP id 2adb3069b0e04-52cdf579dd2so802275e87.3 for ; Sun, 23 Jun 2024 00:54:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1719129267; x=1719734067; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=RAeDnfewhPJ5ExBnkb+H+V2IVbPfmhZdQa+8rfrAYkw=; b=Wopr/nC9A80hYD9GdzXYb3Q4gH/ODakgClkhj8Iqz/uyq2nNKlYEwdZMqoX4oTb/xH jxQiiDVAMYUWd11AUgM1SZch5OkvAurC2IRVsfoEi0FgBO8iDyESA7xD/esRRFVKyHtE s1i6EnI32yFTAF0LK6tKA/n7h3xTkisOoOWBkRh4F7Etz8b4afw4rbU9qKcqew1iYyQy krngf61xm5PyrTJCJ/x5rF9hQcu5Bh7njqqXszoQYvc/BdKFJdD45ct9jHA431Dug0po x0i4hyRNBD9JNY886bevgbA7xBUAasn1FHfyCIfEraDD7VXIK3yK9gLpJnI8Ww8pdDO1 H67g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1719129267; x=1719734067; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=RAeDnfewhPJ5ExBnkb+H+V2IVbPfmhZdQa+8rfrAYkw=; b=frTxswDZ8IJZ9B6fBa5OF0y0U/OktftgpWxaKZqIEmHaoMwNx55HxRjsMs9aX4KpeC Vzp+4lSOA88bDEbkbqgLuC5WBy0C3O4ETmdm/rlKEDef6OMBwxRK5Wrqn7OIEDqSDiM+ l+e8cCjM2CBLlCmvsku4wYZHJzlYDnjQVQ1t4cqPmFE69eAb7d080JOm07pM5UxH7gxg J+xTH5Nk40LJiXMn+Vb3oPNzKpvNxo/6e2P0q99VSaiZBnVhPPvLH9hfKOGzEE69S7rM Mb8f4KVOGJ4xEfrq1GFUjdsTJQJeKMH6S1vmmsfDpFQgjeWaoTkIXq+/cIZv0qRLOkrT qn9w== X-Gm-Message-State: AOJu0YxDT2BsNNY3lu0YOq6T6TUtQb6mVQ2GoXwBCkRLXcF4zLzopvK1 dE1kUFN1ktJg9u+yMYKwU8kLhbFrPRXlqzczzftwIKj6TgS1qNqtOZ4fLmULZ+4R7APG4wMKST9 KNBIq3kQw4fjLxgN2W9VKmURkEgw= X-Google-Smtp-Source: AGHT+IHACUumOYk4WT57A7h56PVi9+7b3q722kIX/LRKZts2Veg3XP13R3VdVROE1/mVzlzA9wldX55ZI4NKe29TpXk= X-Received: by 2002:ac2:5618:0:b0:52c:dea0:dd55 with SMTP id 2adb3069b0e04-52cdf7f10d2mr1497939e87.24.1719129266564; Sun, 23 Jun 2024 00:54:26 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Muhammad Ikram Date: Sun, 23 Jun 2024 12:54:09 +0500 Message-ID: Subject: Re: Upgrade PG from 12 to latest To: Doron Tsur Cc: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000041b488061b89f9ed" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000041b488061b89f9ed Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Doron Tsur, Could you please look into https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstan= ce.PostgreSQL.html https://aws.amazon.com/blogs/database/best-practices-for-upgrading-amazon-r= ds-to-major-and-minor-versions-of-postgresql/ Best of luck :) Regards, Muhammad Ikram Bitnine Global. On Sun, Jun 23, 2024 at 12:09=E2=80=AFPM Doron Tsur wro= te: > Hello Folks, > > We are running PG 12 on AWS RDS. I want to run an upgrade process for the > DB. The org I work for attempted to upgrade before but failed (12->15). T= he > upgrade resulted in unexplained slowness, and performance issues were onl= y > resolved via a downgrade. Do you have any upgrade docs or recommendations > you can share about the upgrade process before I try to go on the journey= ? > > > Thank you, > -Doron > > --=20 Muhammad Ikram --00000000000041b488061b89f9ed Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable



<= div>Regards,
Muhammad Ikram
Bitnine Global.

On= Sun, Jun 23, 2024 at 12:09=E2=80=AFPM Doron Tsur <qballer@gmail.com> wrote:
Hello Folks,

We are running PG 12 on AWS RDS. I want to run an upgrade=C2=A0proce= ss for the DB. The org I work for attempted to upgrade before=C2=A0but fail= ed (12->15). The upgrade resulted in unexplained slowness, and performan= ce issues were only resolved via a downgrade. Do you have any upgrade docs = or recommendations you can share about the upgrade process before I try to = go on the journey?=C2=A0


Thank you,=
-Doron=C2=A0



--
Muhammad Ikram

--00000000000041b488061b89f9ed--