3 ms·
pg_dump is a completely different category as it’s a machine portable logical backup. You can restore an older version backup to a newer version installation as
by koolba 3y ago
pg_dump is a completely different category as it’s a machine portable logical backup. You can restore an older version backup to a newer version installation as an upgrade mechanism.
Just about every other backup program concerns itself with binary backups which generally facilitate point in time recovery as well.
Both have their place and it’s common to have both done on different schedules. Though purely logical backups get interesting at scale as it literally has to run a SELECT * on every table from scratch each time.