public inbox for [email protected]
help / color / mirror / Atom feedGuidance Required for PostgreSQL Major Version Upgrade in Pacemaker HA Cluster
2+ messages / 2 participants
[nested] [flat]
* Guidance Required for PostgreSQL Major Version Upgrade in Pacemaker HA Cluster
@ 2026-04-17 05:55 Jaya Sandeep <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Jaya Sandeep @ 2026-04-17 05:55 UTC (permalink / raw)
To: [email protected]
Dear PostgreSQL Community,
I am currently planning a major upgrade of our PostgreSQL environment to
the latest stable version and would appreciate your guidance on the best
approach.
Our current setup consists of a high-availability cluster managed by
Pacemaker on a Linux operating system, configured in a master–slave
(primary–standby) architecture. Given the critical nature of this
environment, we want to ensure the upgrade is performed with minimal
downtime and without compromising data integrity or cluster stability.
I would be grateful if the community could share insights or best practices
on the following:
-
Recommended upgrade strategy (in-place upgrade vs. logical replication
vs. dump/restore) for a Pacemaker-managed HA cluster
-
Handling failover and cluster resources during the upgrade process
-
Any precautions or common pitfalls specific to Pacemaker-based
PostgreSQL clusters
-
Suggested sequence of steps to ensure a smooth and safe transition
*Details :*
Current version of PostgreSQL is *14.6 *
OS: Linux
HA :Pacemaker Based
Master -Slave --Setup
If anyone has experience performing a similar upgrade or can point me to
relevant documentation or case studies, that would be extremely helpful.
Thank you in advance for your support.
--
Regards & Thanks,
Jaya Sandeep
Mobile: +91 94927 27845
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Guidance Required for PostgreSQL Major Version Upgrade in Pacemaker HA Cluster
@ 2026-04-17 13:13 Ron Johnson <[email protected]>
parent: Jaya Sandeep <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Ron Johnson @ 2026-04-17 13:13 UTC (permalink / raw)
To: pgsql-generallists.postgresql.org <[email protected]>
On Fri, Apr 17, 2026 at 1:55 AM Jaya Sandeep <[email protected]>
wrote:
[snip]
> *Details :*
> Current version of PostgreSQL is *14.6 *
>
Step #1 is to update to fix the 3.5 years of bugs from 14.6 to 14.22. Each
node update should take no more than 5 minutes.
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-04-17 13:13 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-04-17 05:55 Guidance Required for PostgreSQL Major Version Upgrade in Pacemaker HA Cluster Jaya Sandeep <[email protected]>
2026-04-17 13:13 ` Ron Johnson <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox