Try out pg_probackup. It works on database files directly. Restore is as fast as... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		rszorness on Aug 2, 2022 \| parent \| context \| favorite \| on: Use one big server 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.

xuki on Aug 3, 2022 [–]

For MySQL there is xtrabackup - https://www.percona.com/software/mysql-database/percona-xtra....

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact