Loading...

PostgreSQL Backups

You can back up an entire PostgreSQL database or individual databases.

You can run backups immediately or configure a schedule for the subclient.

Full Backups

PostgreSQL full backups include the entire database and the log file. A full backup is the most comprehensive backup and is the baseline for incremental backups.

Full backups are supported by DumpBasedBackupSet and FSBasedBackupSet subclients.

Incremental Backups

A PostgreSQL incremental backup contains the changed data from the last full backup. Incremental backups use less media and resources than full backups.

In a cumulative level n backup, only the data that differs from the most recent backup at level n-1 or lower, is backed up.

Incremental backups are supported by FSBasedBackupSet subclients.

What is Backed Up

DumpBasedBackupset

  • PostgreSQL system databases
  • PostgreSQL user databases

FSBasedBackupSet

  • PostgreSQL databases (data and logs)
  • Log files

What is Not Backed Up

  • PostgreSQL application files
  • Operating system data

Note: Use the File System Agent to backup these components.

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