PostgreSQL DBA

Backup, PITR & Restore

Question

Logical dump versus physical base backup: what does each capture, and when should each be used?

Answer

A logical dump reconstructs selected database objects through SQL or an archive; use it for portability and selective restore. A physical base backup copies the cluster’s files; use it with WAL archiving for cluster recovery and PITR.

This is 4 of 23 free samples for PostgreSQL DBA.

More PostgreSQL DBA topic samples