Ask HN: Largest Postgres DBs?

Re:Ask HN: Largest Postgres DBs? by nunesvn on Tuesday May 30, 2023 @09:56AM (#36124947)

I really would like to know details on how people backup, dump, migrate and upgrade DBs of this size.

[ Parent | on HN ]

Re:Ask HN: Largest Postgres DBs? by halfstar91 on Tuesday May 30, 2023 @10:37AM (#36125381)

Incrementally usually :)

[ Parent | on HN ]

Re:Ask HN: Largest Postgres DBs? by nunesvn on Tuesday May 30, 2023 @06:45PM (#36132133)

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)

[ Parent | on HN ]