What are the most common backup techniques?

Point-in-Time Recovery (PITR)

Point-in-Time Recovery (PITR) is a technique that enables a database administrator to restore or recover a set of data from a backup that dates back to a specific point in time. Once PITR begins logging a database, the administrator can restore a database backup from a specific point in time. When someone unintentionally deletes a table or records from a database or if something goes wrong and corrupts the current database, PITR is crucial. The quickest way to handle this is to collect the transaction logs and restore the database to a previous "known good" point.