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 1sLHLg-00EDOt-Ko for pgsql-general@arkaria.postgresql.org; Sun, 23 Jun 2024 07:09:16 +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 1sLHLe-006CX0-CT for pgsql-general@arkaria.postgresql.org; Sun, 23 Jun 2024 07:09:14 +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 1sLHLe-006CWs-0j for pgsql-general@lists.postgresql.org; Sun, 23 Jun 2024 07:09:14 +0000 Received: from mail-pf1-x436.google.com ([2607:f8b0:4864:20::436]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sLHLc-0036Wo-7l for pgsql-general@lists.postgresql.org; Sun, 23 Jun 2024 07:09:13 +0000 Received: by mail-pf1-x436.google.com with SMTP id d2e1a72fcca58-706738c209bso245849b3a.3 for ; Sun, 23 Jun 2024 00:09:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1719126549; x=1719731349; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=bCGt9hwb3lxCuM55qPF7lxgQ3nUA4gqRkk+rqkHeHkE=; b=iq9BBblOOsG+EIZx9iDexlu7sekV7UEIfOKXOoZ2hpbrpr7Th0T+kj2AS87MEzIqLX gcK0MhxBKUJn1BxybQL0Oj8KJIWXt2XAk+3iDx7s4EWH5yzdEnrmfz0h93e0HyE6Ilyp XJl7GXrnE1cBlEcS0P+9EnFv1t7LGP7ZxV6zVGIMBcerDZ581bJibg3ux4NicK//4tMC Y54A4bNwQ5X+Dk+9/zxuxFWom8nSRQWGr5BcJkFhOjPiJ5JH5x/uphUZn6oDEQ8E4pdQ cVO/IRty8vpMkEpQEaocKDi59Lu6wJ5ggVxcob/ZP/lXf0aCHMwF1rndgdEUg1gWPKOv aOcA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1719126549; x=1719731349; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=bCGt9hwb3lxCuM55qPF7lxgQ3nUA4gqRkk+rqkHeHkE=; b=q5QS5jiB2JnGph6IOzttbxA3vrBf/abcTQtohCfK/5H34Mr294WdnHd+Z3NAR2iwQO 7wS4qWq/ZW6AJLwcf+2c0QQwXvb/22RGm4NYJ3cVbE5nmuwSwc0FCu8gEIuGnOogTbqX CtEmm9B69sdFWGcevNGzXM/YLFwgwXDECWDZGsz0ldcraqivKGEYL8r5ADAwzm/AZOnB NM7BgaP+p+BU1Ym3HnAj1WGMQMtFpZoZHND0iJgKh75aRLDvAIFx4/qc+6wGyPr1Xh+8 9zMX+C9eOMyY9jZ9pDlG22a8Arab4e3XqH176NdiNrdHNc+tHmrCL1apqrXAW8vjW3NG G89A== X-Gm-Message-State: AOJu0YyF1/6RtgD1Zojp81iKYWWinfsaHzyw4Cc/f4r6hQN6LnYx+fGJ QxjIN20HsFUSbIq8pNGzYL0EdjSm4Z1ocdAONMZdmjk9Z+JJQPTnGd1a0lmMcu/gwZeQAnJSv/v XNz/aNAZzZF4r2m7hUXaxiLJV3mdUrUl69sU= X-Google-Smtp-Source: AGHT+IETZt8Ty9X+yFFyAIye3h3vh8KCV1Iy3y97fcHfjIXjVu3edoWX3gpOTUCH+GPTjXZ1tHNDUd1hPiAXNg8j9lg= X-Received: by 2002:a05:6a20:9793:b0:1ba:f8c0:711c with SMTP id adf61e73a8af0-1bcf7ee6679mr951767637.37.1719126549380; Sun, 23 Jun 2024 00:09:09 -0700 (PDT) MIME-Version: 1.0 From: Doron Tsur Date: Sun, 23 Jun 2024 10:08:57 +0300 Message-ID: Subject: Upgrade PG from 12 to latest To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000004cc891061b895752" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004cc891061b895752 Content-Type: text/plain; charset="UTF-8" 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). The upgrade resulted in unexplained slowness, and performance 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? Thank you, -Doron --0000000000004cc891061b895752 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello Folks,

We are running PG 12 on AW= S RDS. I want to run an upgrade=C2=A0process for the DB. The org I work for= attempted to upgrade before=C2=A0but failed (12->15). The upgrade resul= ted in unexplained slowness, and performance 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

--0000000000004cc891061b895752--