The PostgreSQL agent is designed to efficiently manage and protect business critical data in PostgreSQL databases. You can use this agent to backup and restore the entire PostgreSQL server or individual databases. If necessary, you can also restore individual tables.
Key Features
Block-Level Backups
You can use block-level backup as a faster method to back up data because only the extents (or modified parts of the database) are backed up rather than the entire PostgreSQL database. You eliminate the need to run a full backup each time the database is changed. For more information, see PostgreSQL Block-Level Backup.
Automatic Discovery of Applications
You can use the Auto discover applications option to automatically find PostgreSQL databases in your environment and install software to back up the PostgreSQL databases. For more information, see Automatic Discovery of Applications.
A Wide Range of Backup and Restore Operations
The following table describes the backups and restores that can be performed on the PostgreSQL Agent:
Feature |
Uses |
Backup type |
Backup options |
Backup set |
Restore options |
More information |
---|---|---|---|---|---|---|
Backup of databases from an instance hosted in cloud using pg_dump utility |
|
Traditional |
Full |
DumpBasedBackupSet |
|
|
Backup of databases from an on-premise using pg_dump utility |
|
Traditional |
Full |
DumpBasedBackupSet |
|
Creating a PostgreSQL Subclient to Back Up Specific Databases |
File based online data backup with WAL files |
|
Traditional |
|
FSBasedBackupSet |
|
|
Snapshot based online data backup with WAL files, followed by file system backup copy |
|
IntelliSnap |
|
FSBasedBackupSet |
|
|
Block level backups using snapshot based online data backup with WAL files, followed by file system backup copy |
|
Block level |
|
FSBasedBackupSet |
|
|
Live Sync replication |
Continuous synchronization of master server to standby server by restoring logs from the backups taken for master |
Traditional |
|
FSBasedBackupSet |
As applicable for traditional backups of FSBasedBackupSet |
|
Backup from Standby Server |
|
|
Based on the backup type selected |
FSBasedBackupSet |
Based on the backup type selected |