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 1w7IG9-0059ea-0p for pgsql-admin@arkaria.postgresql.org; Mon, 30 Mar 2026 19:26:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w7IG6-005wv8-21 for pgsql-admin@arkaria.postgresql.org; Mon, 30 Mar 2026 19:26:47 +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.96) (envelope-from ) id 1w7IG5-005wux-1a for pgsql-admin@lists.postgresql.org; Mon, 30 Mar 2026 19:26:46 +0000 Received: from mail-vk1-xa2a.google.com ([2607:f8b0:4864:20::a2a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w7IG0-0000000234i-0rNa for pgsql-admin@lists.postgresql.org; Mon, 30 Mar 2026 19:26:45 +0000 Received: by mail-vk1-xa2a.google.com with SMTP id 71dfb90a1353d-56ba039eecbso1711244e0c.0 for ; Mon, 30 Mar 2026 12:26:40 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774898799; cv=none; d=google.com; s=arc-20240605; b=Nz71Cl5es2mWVxoY0uL/Ts2OpNyXA9gJup3JXL04kgs2k3XzgM8rFqNnMMCDmWYFM2 4pS5niXdf83mYifjFnizexPa8oBWY5mvIQMWkTBQ0K4lGSITtGLDs1weDZynbL9C6Cjr dsZlvnujLz3IGScuxedOLMW9OI7CvR29dbKykUqA25eIHtBhxTXyTr3ltBI0+WoaUhRX a5FCGvi2FSDawlB3/fONANCOWfIGN/fi2r0Ec3xsZq25uxf+WmmUMHyBT7wsyWHKH2Md S4sP3VB8aJhWNNfj2/3syILa4Yzxp1d5Xjpa5W5ynY2bjMXdutH1n38V/JlKGgUxva18 BzxA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=YQDTPDyZYXF3t++ma7LvvkQfhy82YNROXxlL4KZCPAU=; fh=mJ+hrje4Z/aZ+NSariEK+ETmTcTxKxlBga5JTBs5v+U=; b=e8L6pPxbCjvvOaawQkLJJaLH8pCMFFtrcbWpP1KYclXNn1YNkKdTZpNlZH2OU/vg36 D17OEcWpuEmnYWwckPoK3sjtcG9T7RkhGvVg5orhkf/OQRz7Xsl+d1EysDJ2t45ITzuQ e6Aqjf8UfWVHr3Pht/uYtph1vBbpGkhyHAyPrLAyb11P4MPuJhDVD3wTlLMDpcud41gu 2bxWjaSE7JnZzhGnR1kFo0ZpbI7uNt349EK3axK74kvvq+1ikxnQ1WWWKh0Skj/TYNaE 8b7ETVQy2eMHPNbca6B8+KEYO4SKRFapxRjWstH4eImJvb12ynD/ZOpEUcL6oqHtiluw zLCA==; 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=xzilla-net.20230601.gappssmtp.com; s=20230601; t=1774898799; x=1775503599; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=YQDTPDyZYXF3t++ma7LvvkQfhy82YNROXxlL4KZCPAU=; b=wxcZUVt8mj0GGbFHxlgUStYuB/a6WbXjEbDKrLdQ/MxKtDc+PrGeUHSUMYBYwfeOF+ EeLEUiBQ4Er27SezVo1GLxJ9DW95Z8NNerpyH8zlj/c8VaX1urRMkSkiKM9qSzahk/MR qGk/mplogZ9cjCOh0RI4IZjMl0M3K+fJVczuA6a8r70p877n2D/TZiupdGb65HRluW/L 8tX/9AKd44gtb8CyVGWRWozhcLPfKltEKds5bU8xmQEZ5LGnOaeFMHXb4Oi5TpqEwhKe 8I9zsXPq8fGNMR04kBdd1D9mYlzwlc6KGWzbzJl9lXNyJO12kppQBVnzNdAzd/bbeVeF TQSg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774898799; x=1775503599; h=content-transfer-encoding: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=YQDTPDyZYXF3t++ma7LvvkQfhy82YNROXxlL4KZCPAU=; b=nw5l/RgqO0SvIV7694CURRKmyRxJy16mxcosHYSI6GuuQQiOf5dwRDjYTanhYQ8Qqc c3A/OaxagkvyGt71QfU0TIhlTwR+6TiYC/on23b220iyeM4Kqvgkh3o/2QWpC0ip+sq8 y6BQIqOqlFWLgbjsGRleljQqOM0pEobvkDtXQpTq+TCsrnovH3359faxymqmjrPes/XD r/7TUqUs8M0xOINnZb1bHbBQoxId6NEtRZx0FVCrfsGb7fLuzZabWsbCoX+YhoBBW332 w+97IkRHYBuHAmN4xQBYIA48ygCRllsm3nexRabc+dxj7CDkoI9Y4o4DxH52zmheFxD9 9TdA== X-Forwarded-Encrypted: i=1; AJvYcCVLZ5XgXg1TULUs/rBaXV/KfPkRh/SbyIf3WHzXNfFlQFxNDO1DADpPyLaaYBk8e2dqOsRcGUtogcpSAA==@lists.postgresql.org X-Gm-Message-State: AOJu0Yz6U6IPwXuUiCMVO6xdg60kFXyi6tGXZw0rSWr9iGH1ZUiDJGIQ grsokNXzESq21Bi0K6WPJI5MK9KzwSwQFBec2iTfeo+oPdZMZoXO1/EWtzGT8NHCsRShYbNQxB4 2FDxMEfYq567ZP8F5tiVWeCWKDGJFaiCoj7QQBOVMM2vKlltINfMR X-Gm-Gg: ATEYQzxeztONnUU7h4ZXdfVX3R980749DPTXYlEjTq/xnzGaUFjI6IO+VbR5iK9xXqZ 2dWdpUbmP2o4FAIZUxu+w4zvQVpG3Hm1siYiQGuLq3ZQYyBEDyt6mLQPeLPBpXbrUpoVie9Bj0q 37W3tLcv/D45WlccDPvtDgzxpQJXVscLdj4qmQ1lN5FzzPzTgsWL5Hyc3wppAWIC7rLLGWsQnVj AhrkIAedWkxQjHFp2PfDDr7O0pZWwbG+d6fm9dp3IWfCjvbEEZL6M9p1VYHxE9VzTHde7571imz Ptd82/E= X-Received: by 2002:a05:6102:3046:b0:605:f9e:ced4 with SMTP id ada2fe7eead31-6050f9f0666mr2908209137.24.1774898798851; Mon, 30 Mar 2026 12:26:38 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Robert Treat Date: Mon, 30 Mar 2026 15:26:27 -0400 X-Gm-Features: AQROBzDJVzSKK8NwbpTkTBXDP-hi3EueGahcogIFhahRC9FYoJC34azvyFQJrwY Message-ID: Subject: Re: Pg upgrade from 13.20 to 17.9 To: Ron Johnson Cc: Balaji Ram , pgsql-admin@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Mar 30, 2026 at 11:37=E2=80=AFAM Ron Johnson wrote: > 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 lar= ge version gap before, so I=E2=80=99d appreciate any guidance on best pract= ices, 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 alw= ays Best Practice. > +1 to the above, pay special attention to any incompatibilities information. If you want to be really thorough, you should look at the first few minor release for each branch to see if there are any system catalog updates or reindexing type activities you need to deal with. Also, if you have any extensions, you'll need to verify that those will also survive such a big version jump; there's an outside chance you may need to stop at some major version along the way. Oh. and if you don't have a strong reason against it, most would probably recommend you go to v18 at this point. Robert Treat https://xzilla.net