Search Postgresql Archives

Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thank you for your valuable suggestion!

I have a question regarding the process:
When we shut down the standby, upgrade it, and then start it back up, will the replication automatically resume from the primary to the standby?

Looking forward to your clarification.

2) What do you mean by resource-intensive?  If it means network bandwidth, then read the pg_basebackup man page.
  No, it’s not about pg_basebackup consuming resources. What I meant is that in the event of a failover, if we need to bring the standby back online, the process of running pg_basebackup takes a significant amount of time. However, if using a cron job for this purpose is a viable option, then that would be acceptable.  



On Sun, 24 Nov 2024 at 22:27, Ron Johnson <ronljohnsonjr@xxxxxxxxx> wrote:
On Sun, Nov 24, 2024 at 11:52 AM Subhash Udata <subhashudata@xxxxxxxxx> 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!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux