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 1w77nm-004z9B-2x for pgsql-admin@arkaria.postgresql.org; Mon, 30 Mar 2026 08:16:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w77nl-0028JP-1O for pgsql-admin@arkaria.postgresql.org; Mon, 30 Mar 2026 08:16:49 +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 1w77nl-0028JG-06 for pgsql-admin@lists.postgresql.org; Mon, 30 Mar 2026 08:16:49 +0000 Received: from mail-dy1-x1332.google.com ([2607:f8b0:4864:20::1332]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w77ni-00000001xex-3TTC for pgsql-admin@lists.postgresql.org; Mon, 30 Mar 2026 08:16:49 +0000 Received: by mail-dy1-x1332.google.com with SMTP id 5a478bee46e88-2bd9a485bd6so8288204eec.1 for ; Mon, 30 Mar 2026 01:16:46 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774858605; cv=none; d=google.com; s=arc-20240605; b=k4HKWL5xnQv2txWiw4YLQEX9Rq4nd2Y7VSgD6PdFag9iGLJgp3ot0FeskouC7u1Wka XQ/+/v3ygXcSoS87ZhK5dJggBa7mt0BRVaPEUlw7+tH6IfKVRh+OVGHVtHeOg4RpLnyK TCwgIVH3RE8LhkAfuOTywyCF92MIcLXprlTPeb0m5jEMf6TnKK/dR9SZvTvw7zzH6vdK qeIMebD38feKctPObWffYwzw/0jKUcyuTNTaxvb5/A+wz5nfaFUVdfI/U4Ang0+ZassD 61AZFoqgTCniGbrN9GC/sxAn8SGOaFC3L8cV3QIv7sECYkBB45GigbyP6rI5pgAyBWa+ XkBw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=JiU7A4JGBWBQDt5UlMZzfBv3bqIIYDX5wuEbX5gul8c=; fh=2TYDFu6n7J5QCgQuKC9CHnL0/OX+GX+HLe30lvVBdcM=; b=WDUnDXQp0tKkbb3JALl8eR6M1K7jJbffXGv90wXfGNHzhixOcx0F9w3l1XoQnXvuYD Go608po73nKxAlgTlqrv56sD86mXQSLsu0bQ/4ofj4EpjXaPLJOWYJ8r5ovMoPNkUbI7 7oWbXWMUbcl73T3TfzYoAyDPT16pgcPh9WTPL2/MCejA3s7XMqKrbyBmliCq5MQyiOto BO7DNeot7mTs2QXgO/m+g7ZpIHG0BgiYuj0Nkd/pshN+tzmYWnqyD6fCxqH3VxpmpjNT YQiOCaEgHRca/P/Ya0i4NW/EdtZ5lQRII44RjX5AuSGOHVpWKzLAQcnnunofYVGBtX+D FVGw==; 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=1774858605; x=1775463405; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=JiU7A4JGBWBQDt5UlMZzfBv3bqIIYDX5wuEbX5gul8c=; b=MlCMgttaQA86Q/issLvFWwpaJJoGMcqW/VNQrks/wOqTdkSAr8ShFFfc7ud3+bph09 62PQLaSO2eVQgqw1MdEUAOQXCqK+TR3idYkg2uD5N2ieozMd5y60wN9eAOyz7JB0Up// CuYlv7iYKoLuAN+G17ydxr4Z7Q9hp/7Lrgp/5rRGC9Ed558u4ZXegEzWoUibyFPXYnNC bnM3OC5Dvg4U8WE1QYr/JrSpphUeJPxWBm04JvfZELk3JuFa1TL4lXwFo2xX8HXMjyN8 B5Sldl7xtT5NGGBmVL4qPex20UZXNTmjYIVg0BPVojCtLL3oK0CAGNeSW9Sr7lRFEblT DECw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774858605; x=1775463405; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=JiU7A4JGBWBQDt5UlMZzfBv3bqIIYDX5wuEbX5gul8c=; b=e4+uVBgtA/Vzr7HVk+4Fm8OS48e/4AVCnLNIAjq7zs92tSJWbKFIeqFQq5c0fQspTX 0MMhmAQDuwWVDFmyQwgVIDxURRI6xz9CdVFuwxLdWJsMICfpWHUmnjTCQnKHSqTr6trY TyZRHnLnrrw5cPQksdO+KYLgcnMJna9JUpjdUTwOhQAaGN5RrgkWS40u6nBx8oiXQfaC 1XC1Ntii03jR+kB5DmngAROacDXxOft7p7Npn3edY61tjPT++TSMww9jRhuYFf+gkK9Q dsJFMfhk5lLhoh9WmZtPtYY71jR7R4mK9yyWXQx3D9LKLkbQBhWQK2CqnfHGE8zHa62D I+nA== X-Gm-Message-State: AOJu0YycR4stEtlIqkvAClZmDojh4z8ZTSjwbGkNagGmclGFvTbWTKNx HtCy5s2/3kKytTCW/rnDIkH2RbgwtEcw12aYoCllS8L+NE+idS2SoVO/mH7wPfTxbao5Ik+ZFoq cgYBbZHMNtqp41RWY3eB9RIGNGmOqeWzIDg== X-Gm-Gg: ATEYQzxgSzldXj9cN0Xd9IenDO1EwAIp5kADcJ2ybVYVDh4T+IRlbE00WvRZDec/lmp xWM5WzUXRFIiKe2yhRbnxwFw6swkzNy/11X3lRrXdA+tluPaYOq/nB+pQ12uDODX9DrkBHpPqO8 3wXsfBa3DwM/pCv1AkPasyVSaOBRSZmvNVUljLzvGcgb0WMPa+majK/ge+wq93L/Qemhmfuh28J r5d4TY+h0rNOgtaJGWaVG9xYxMcfKx7+nl9LeajYommb1bwnn0viPFhx26cN0DTRBThnBMwoKe9 8MgHjFf5AIXaCVvFvo95rdSVdJnZX8BXiNXslx4nIl2EloDVLYk= X-Received: by 2002:a05:7301:129b:b0:2c1:5b23:1752 with SMTP id 5a478bee46e88-2c185f5a3c7mr6125761eec.23.1774858604575; Mon, 30 Mar 2026 01:16:44 -0700 (PDT) MIME-Version: 1.0 From: Balaji Ram Date: Mon, 30 Mar 2026 13:46:32 +0530 X-Gm-Features: AQROBzCFWFxmJKKpt16thGm71hKMHpgebAuSusYOYJawdNl7M5eVuSJ7qvD8H_U Message-ID: Subject: Pg upgrade from 13.20 to 17.9 To: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000a6ffd2064e397809" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a6ffd2064e397809 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 practice= s, recommended approaches, and things to watch out for. Thanks in advance! - Balaji --000000000000a6ffd2064e397809 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Everyone,
I'm planning to upgrade a standalone PostgreSQ= L cluster from **13.20 to 17.9**. I haven=E2=80=99t performed a major versi= on 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.

Thanks in adva= nce!

- Balaji
--000000000000a6ffd2064e397809--