public inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedPg upgrade from 13.20 to 17.9
4+ messages / 3 participants
[nested] [flat]
* Pg upgrade from 13.20 to 17.9
@ 2026-03-30 08:16 Balaji Ram <balajiram.ganesan@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Balaji Ram @ 2026-03-30 08:16 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi Everyone,
I'm planning to upgrade a standalone PostgreSQL cluster from **13.20 to
17.9**. I haven’t performed a major version upgrade with such a large
version gap before, so I’d appreciate any guidance on best practices,
recommended approaches, and things to watch out for.
Thanks in advance!
- Balaji
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Pg upgrade from 13.20 to 17.9
@ 2026-03-30 15:37 Ron Johnson <ronljohnsonjr@gmail.com>
parent: Balaji Ram <balajiram.ganesan@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Ron Johnson @ 2026-03-30 15:37 UTC (permalink / raw)
To: Balaji Ram <balajiram.ganesan@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
On Mon, Mar 30, 2026 at 4:16 AM Balaji Ram <balajiram.ganesan@gmail.com>
wrote:
> Hi Everyone,
>
> I'm planning to upgrade a standalone PostgreSQL cluster from **13.20 to
> 17.9**. I haven’t performed a major version upgrade with such a large
> version gap before, so I’d appreciate any guidance on best practices,
> 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.
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Pg upgrade from 13.20 to 17.9
@ 2026-03-30 19:26 Robert Treat <rob@xzilla.net>
parent: Ron Johnson <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Robert Treat @ 2026-03-30 19:26 UTC (permalink / raw)
To: Ron Johnson <ronljohnsonjr@gmail.com>; +Cc: Balaji Ram <balajiram.ganesan@gmail.com>; pgsql-admin@lists.postgresql.org
On Mon, Mar 30, 2026 at 11:37 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
> On Mon, Mar 30, 2026 at 4:16 AM Balaji Ram <balajiram.ganesan@gmail.com> wrote:
>>
>> Hi Everyone,
>>
>> I'm planning to upgrade a standalone PostgreSQL cluster from **13.20 to 17.9**. I haven’t performed a major version upgrade with such a large version gap before, so I’d appreciate any guidance on best practices, 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.
>
+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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Pg upgrade from 13.20 to 17.9
@ 2026-04-01 15:55 Balaji Ram <balajiram.ganesan@gmail.com>
parent: Robert Treat <rob@xzilla.net>
0 siblings, 0 replies; 4+ messages in thread
From: Balaji Ram @ 2026-04-01 15:55 UTC (permalink / raw)
To: Robert Treat <rob@xzilla.net>; +Cc: Ron Johnson <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org
Hi All,
Thanks for the suggestions and guidance.
I reviewed the release notes across versions and completed the upgrade
successfully in a test environment. Everything looks good so far.
Appreciate the help!
Thanks,
Balaji
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2026-04-01 15:55 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-03-30 08:16 Pg upgrade from 13.20 to 17.9 Balaji Ram <balajiram.ganesan@gmail.com>
2026-03-30 15:37 ` Ron Johnson <ronljohnsonjr@gmail.com>
2026-03-30 19:26 ` Robert Treat <rob@xzilla.net>
2026-04-01 15:55 ` Balaji Ram <balajiram.ganesan@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox