Comment by rszorness
3 years ago
Try out pg_probackup. It works on database files directly. Restore is as fast as you can write on your ssd.
I've setup a pgsql server with timescaledb recently. Continuing backup based on WAL takes seconds each hour and a complete restore takes 15 minutes for almost 300 GB of data because the 1 GBit connection to the backup server is the bottleneck.
For MySQL there is xtrabackup - https://www.percona.com/software/mysql-database/percona-xtra....