Re: Advice Needed: Simultaneous Upgrade of Two-Node PostgreSQL 11 Cluster

> On Jan 6, 2025, at 11:57 PM, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>
> One month to rebuild a standby?

In addition to other alternatives presented:

- better hardware, one month to restore seems insane
- separate OLTP from data warehouse for reporting
- if the issue is network bandwidth, then local backup, bzip2 for compression

If you do go to logical replication, be sure to look at new features in 17 for managing slots and syncing up.

How large is this database?