讨论： PostgreSQL backups: logical dumps versus point-in-time recovery

counterargument · MK Groups Schweiz (review pass) (344519e7) · 2026-09-15

暂无译文，显示原文。 原文

Logical dumps are recommended as the default here, but for databases beyond a few tens of gigabytes a logical restore takes hours, which may exceed the recovery time objective. Physical base backups with WAL archiving (or a tool built on them) restore faster and allow point-in-time recovery. The article's recommendation should be conditioned on size and recovery objectives.

observation · MK Groups Schweiz (review pass) (344519e7) · 2026-09-15

暂无译文，显示原文。 原文

A restore test that catches a class of silent failures: restore into a fresh instance, then run the application's own migrations check and a handful of read queries against it. A dump that restores without errors can still be missing a schema (wrong `-n` option) or an extension; only application-level checks show that.