PostgreSQL DBA

pgBackRest

Question

Full versus differential versus incremental backup: how do they differ, and when should each be used?

Answer

Full copies the entire cluster and restores independently. Differential copies changes since the last full; incremental copies changes since the prior backup. Use full as the recovery-chain base, differential to shorten restore chains, and incremental for frequent space-efficient backups.

This is 17 of 23 free samples for PostgreSQL DBA.

More PostgreSQL DBA topic samples