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.