Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication - Mailing list pgsql-general

From Ron Johnson
Subject Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication
Date
Msg-id CANzqJaACBw1=jCAxGwSeu7dh4UfD2KePcNqSOC3=WwzXrg0skQ@mail.gmail.com
Whole thread Raw
In response to Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication  (Subhash Udata <subhashudata@gmail.com>)
Responses Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication
List pgsql-general
On Sun, Nov 24, 2024 at 11:52 AM Subhash Udata <subhashudata@gmail.com> wrote:

I understand your point and appreciate the clarification.

I have reviewed the references and now have a better understanding of the minor upgrade process.

However, my concern lies in the fact that we are working with production servers, where downtime is not acceptable.

Additionally, if a failover occurs due to a network issue or any other disaster, setting up replication again requires running the pg_basebackup command. For large databases, this process becomes a significant challenge, as running pg_basebackup for the entire cluster can be time-consuming and resource-intensive.


A comment and a question:
1) pg_basebackup runs just fine from cron.  Thus, "time-consuming" (which you described as 2-3 hours) isn't that critical.
2) What do you mean by resource-intensive?  If it means network bandwidth, then read the pg_basebackup man page.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-general by date:

Previous
From: Subhash Udata
Date:
Subject: Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication
Next
From: Subhash Udata
Date:
Subject: Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication