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.96) (envelope-from ) id 1w7EgP-0056Ho-1T for pgsql-admin@arkaria.postgresql.org; Mon, 30 Mar 2026 15:37:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w7EgN-004Sow-00 for pgsql-admin@arkaria.postgresql.org; Mon, 30 Mar 2026 15:37:39 +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.96) (envelope-from ) id 1w7EgM-004Soo-22 for pgsql-admin@lists.postgresql.org; Mon, 30 Mar 2026 15:37:39 +0000 Received: from mail-oi1-x235.google.com ([2607:f8b0:4864:20::235]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w7EgL-00000001pGU-1G5N for pgsql-admin@lists.postgresql.org; Mon, 30 Mar 2026 15:37:38 +0000 Received: by mail-oi1-x235.google.com with SMTP id 5614622812f47-46726528f1cso2938742b6e.0 for ; Mon, 30 Mar 2026 08:37:37 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774885057; cv=none; d=google.com; s=arc-20240605; b=h3y1kb7nraMkatwjcPCSJunpbfWH9hcTii9nkR4aSTyzpUFvHrGSfQ2zQLKyCxg1BW Ckx3ks1C/WYZmWTZZE+TjGzLNuZM/Uk/If9cAK6D0McgBdwaJG3WyJRtFEjT9oTJiVEN eQ1wHqMNfrK4Bc1x5uEDejH+yjkEWe/c3eenIxFBCysv/TaZCuQCJYJrw7s3batwkNeo 1vF/pq4wkHakb5WoQdn/7nSDlAW5h5k9a+GnApgeNauY2Ut5rjW90dRqANNzIsZsMdKS v39rQwnuQeg1qE5sN3ZWfovszZceLfNlOkXoZ9RRSGT+lfwvF0KWkcYeh7uoK0kfkEqG YRHg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=7VmT5o/jCdO98pXGFvXKAfl5eyozNmf0JDdaG/BKJb8=; fh=1BxR2faBNf1hFOhVyXWT5exDGn2rW6WItWOAzrJBl+U=; b=iWdynMD0vn7K4iVRgV9z277n/1L8+ldPloaC9X3LJaGIVocsbWPdxsfs0TSOmkBkiD KB6GhRrdVBfwK3PNQT4Tgej1K9yY1naeUbqcQVXUNzyEkPlCNGcVlWb/fR1f0BBRBE9Y qr7gDNlXVGPwyvn1gvt0kHQx+WNc3GzidAR/nOrYQFxaS1G6mIJgw5/TJYKHa4ErfpOD kYP3r2anfekceRBRrwAg/hWfHzg6hYL3PByb8lVx859ww0TuHDciQdiJ4LX2CovE97Ju Li2MVs1qMDBkPTHcDdqsDMHEJ5KyQjJ/hX/V+S4/2EIzIU0v8vCdv7Rov7beoj3w4RLW aUtA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774885057; x=1775489857; 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=7VmT5o/jCdO98pXGFvXKAfl5eyozNmf0JDdaG/BKJb8=; b=gD7hM7mIaZ1zy25tFCMhcs9Ct8qIH6tHq0iSKC9tnaxXoSHT9k/499/kcra7V+cSbA XiFSJ7yzgjDdbhRSy4ERdnU33al+4zC2a3c2Ii1CgTDRzWMbHpEYocKERW8v72uMovPV AHDMRil6wIzymaU5OkURtJr5MY4NeSxpJ0dHKdal/a+PvtPNMnv0TpP34qLPU+pOy+Nh 3wqKtKsv20kDX65XSL/p3Iwld//rGLT0fQ7dtGPFeV67lh7tk56mixwj8jttCYNuF3Zz Z/E3XZcvDNPm29o2o+G0B7HX/3iST9K1jGb/nwa2uHkJiceHv+EmEOKJP1wAJdARebBu 4hMw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774885057; x=1775489857; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=7VmT5o/jCdO98pXGFvXKAfl5eyozNmf0JDdaG/BKJb8=; b=m0XkSf4/kJHQNgbPSRFq2j3eIWlYdGVq+ttgRiSIvbqfWwzoG8EU9G+vWVmQhynK7q SY4BTpdyROXE2vi6f+HJnHeNn1RSkhg25VbfQ7/Tl3h7VY+26pCKTNQY96/B3AU2zuKN udHVqsl9p476jfx8zSRDmikUPZigTHwLACCKHFgHs5RFCR7Xs1h80tYqHigzXtaTy6t1 KBjMwckdV+Cmawzf8rGV/t/orrVOb1dxQdxoTOahAmKYdppfOJBHlRyl+DbTsIzt37zN BXPFJ+VjkclTMgFEYUkatSha/ZAs8sH/yj+sch58yYEvaPGe3T/B9bEpiYD/Fpm8NhqZ aJXw== X-Gm-Message-State: AOJu0YxLiyYb9iDh6ifazsjBSUn5ZblAs93xxrWrXWFopZAowYJAr+T1 oHtJQQnMGEteQwJ9Ni+u3cscSEEh5LGCtvTv/O9nU0Uin0TVMXFlFebx8vxC351k0msVVSeU2HX FCIex/fPS5TZRC8FLwKXtWW/9hmp1PhM= X-Gm-Gg: ATEYQzwG0LRNTh6bwmJCXLtW0xIPR0eTRacBVBWivXhG1Q/l/xycLpxypY2bM4kLw+8 TUOSzUc15ySzJ0RinoQDldeofTRTpjwaFrf+TScoh6EjOc4oLUU4OukeI4xaQmS/dpsUX+wh4H5 jlC1fcj5ky/s2CGM7mZaJAvNQMtMJQULOlJdfn0bycnP+6+nTpMWcttJu7Y0wlFReR/Asn91ZvH jBeOOXzWteUQquMcFTOhGuT0fn+B52nTNiEyRuYvG9tXDgp304qNyDK2ICwvI9vOz5FnoDH7oiH Lsdpq3W2hbvMfQsN2Cs= X-Received: by 2002:a05:6808:1928:b0:467:5571:7f3c with SMTP id 5614622812f47-46a8a38f139mr5636206b6e.6.1774885056652; Mon, 30 Mar 2026 08:37:36 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Mon, 30 Mar 2026 11:37:25 -0400 X-Gm-Features: AQROBzBrEuM0xi7R-gQe3R1T_QFBnxofrTDqikyBqUx1fdPQOtwKNLJtCH-h7jA Message-ID: Subject: Re: Pg upgrade from 13.20 to 17.9 To: Balaji Ram Cc: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000051ab1e064e3fa120" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000051ab1e064e3fa120 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Mar 30, 2026 at 4:16=E2=80=AFAM Balaji Ram wrote: > Hi Everyone, > > I'm planning to upgrade a standalone PostgreSQL cluster from **13.20 to > 17.9**. I haven=E2=80=99t performed a major version upgrade with such a l= arge > version gap before, so I=E2=80=99d appreciate any guidance on best practi= ces, > recommended approaches, and things to watch out for. > 1. Read the PG 14, 15, 16 and 17 release notes. 2. Being on the latest is the latest release (in this case, 13.23) is always Best Practice. --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --00000000000051ab1e064e3fa120 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Mar 30, 2026 at 4:16=E2=80=AFAM B= alaji Ram <balajiram.gane= san@gmail.com> wrote:
Hi Everyone,

I'm planning to upgrade a standalone PostgreSQL cluster from = **13.20 to 17.9**. I haven=E2=80=99t performed a major version upgrade with= such a large version gap before, so I=E2=80=99d appreciate any guidance on= best practices, recommended approaches, and things to watch out for.
=

1. Read the PG 14, 15, 16 and 17 rel= ease notes.
2. Being on the latest is the latest release (in this= case, 13.23) is always Best Practice.

--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lob= ster!
--00000000000051ab1e064e3fa120--