Hacker News new | ask | show | jobs
by nunesvn 1118 days ago
I really would like to know details on how people backup, dump, migrate and upgrade DBs of this size.
1 comments

Incrementally usually :)
Yes, but a usual pattern for smaller DBs is, for example, to run a full backup weekly and then daily incremental backups. Also, SQL dumps makes easier to do partial recovery, like for a single table.

On this size class (~1TB) I see PITR backups using something like Barman as the only viable alternative. (Of course you can also copy the whole VM/Disk etc)