easy5 pts · first answer countsbackup-recoverypostgresql

Logical vs physical backup

What is the key difference between pg_dump and a physical base backup (for example with pg_basebackup or pgBackRest)?

A.pg_dump copies data files byte for byte; a base backup writes SQL statementsB.pg_dump exports SQL-level objects and data; a base backup copies the data files and can be combined with WAL for PITRC.They are the same, only the file names differD.A base backup only contains the schema, not the data

← Stopping SQL injection Proving backups work →