النسخ الاحتياطي: المنطقي مقابل الفيزيائي

في هذا الدرس

choose the right backup type.

الموضوعات المخطط لها

• Logical backup (pg_dump, pg_dumpall): SQL or archive of data and schema; portable across versions; slow to restore on big databases; consistent snapshot of one database.
• Physical backup (pg_basebackup, file-level): a copy of the data directory; fast restore; same major version only; the basis for point-in-time recovery.
• A backup is useful only if restored; schedule and monitor both.
• Store backups off the database host; encrypt them.