Waiting for 9.4 – Allow BASE_BACKUP to be throttled

Allow BASE_BACKUP to be throttled
A new MAX_RATE option allows imposing a limit to the network transfer
rate from the server side. This is useful to limit the stress that
taking a base backup has on the server.
pg_basebackup is now able to specify a value to the server, too.
Author: Antonin Houska
Patch reviewed by Stefan Radomski, Andres Freund, Zoltán Böszörményi,
Fujii Masao, and Álvaro Herrera.

Showing this would be tricky, so let me just show some example command line.

Before I'll do that, though, simple information – pg_basebackup gets copy of master (or slave) PGDATA directory (and possibly all tablespaces, if you use them) and saves as either unpacked data, or tarballs.

When working, it might cause some load elevation, simply due to reading all the data.

If getting the backup from your server proves to be too expensive – you can, now, make it slower, with less impact on I/O performance.

The option to do it is –max-rate, so example command line could looks like: