medium10 pts · first answer countsbackup-recoverypostgresql

What PITR needs

A developer ran a bad UPDATE at 14:05. You want to restore the PostgreSQL database to 14:04. What do you need?

A.Only last night's pg_dump fileB.A replica that uses synchronous replicationC.A physical base backup taken before 14:04 plus all archived WAL files from that backup up to 14:04D.The PostgreSQL server log file for that day

← Why PostgreSQL needs VACUUM Risk of asynchronous replication →