On Sun, Nov 24, 2024 at 11:52 AM Subhash Udata <subhashud...@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!
