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

Dear Scott Ribe

Kindly be informed that database size is 1.8 TB and we have an low network
bandwidth between two node 10 mbps and to transfer the data from scratch
that will take from 21 day to 30 day for this we need solution in upgrade
to prevent load data from scratch .

Thanks

في الثلاثاء، ٧ يناير ٢٠٢٥ ٣:٣٨ م Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
كتب:

> > On Jan 6, 2025, at 11:57 PM, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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?