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 .
> 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.
