Re: getting pg_basebackup to use remote destination

On Sun, Dec 30, 2018 at 6:17 PM Chuck Martin <clmartin(at)theombudsman(dot)com>
wrote:

> Maybe I need to rethink ths and take Jeff's advice. I executed this:
>
> pg_basebackup -h [main server's URL] -U postgres -P -v -X s -D
> /mnt/dbraid/data
>
> 8 hours ago, and it is now still at 1%. Should it be that slow? The
> database in question is about 750 GB, and both servers are on the same GB
> ethernet network.
>

Over gigabit ethernet, it should not be that slow. Unless the network is
saturated with other traffic or something. Might be time to call in the
network engineers. Can you transfer static files at high speeds between
those two hosts using scp or rsync? (Or use some other technique to take
PostgreSQL out of the loop and see if your network is performing as it
should)

Are you seeing transfers at a constant slow rate, or are their long freezes
or something? Maybe the initial checkpoint was extremely slow?
Unfortunately -P option (even with -v) doesn't make this easy to figure
out. So alas it's back to old school stopwatch and a pen and paper (or
spreadsheet).

Cheers,

Jeff

>