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

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

 



> On Jan 6, 2025, at 11:57 PM, Laurenz Albe <laurenz.albe@xxxxxxxxxxx> 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?





[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux