PostgreSQL Restores

A database restore might be necessary when the data area or the log area is damaged, to recover from a logical error or to copy the database.

Perform a restore operation immediately after your first full backup to understand the process.

PostgreSQL restores fall into the following main categories:

  • Entire database restore: This is a restore of the entire database and the log file.
  • Database subset: This is a restore of individual databases.

You can perform a restore operation from the latest backup or a backup from a specified date.

Last modified: 3/1/2018 7:45:55 PM