Perform backup and restore operations on the PostgreSQL databases.
To get started, configure PostgreSQL instances and subclients.
When you create a PostgreSQL instance, a DumpBasedBackupSet and an FSBasedBackupSet with default database groups are automatically created.
-
A DumpBasedBackupSet backs up selected individual or group of databases.
-
An FSBasedBackupSet backs up an entire PostgreSQL server which includes all the databases and logs.
You can schedule backups and also run them as needed.
You can restore to the same host, or to a new host in the case of a disaster.
The Command Center provides summary information about the PostgreSQL jobs.
Supported Features
The table provides an overview of the PostgreSQL database supported features.
|
Feature |
Support |
|---|---|
|
Content |
|
|
Database |
Yes |
|
Transaction Logs |
Yes (with FSBasedBackupSet) |
|
Backup Schedules |
|
|
Immediate |
Yes |
|
Schedules |
Yes You can have more than one schedule for each database group. |
|
Backup Types |
|
|
Full |
Yes |
|
Incremental |
Yes (transaction log backups with FSBasedBackupSet) |
|
Restore Destinations |
|
|
Destination server is where you performed the backup operation |
Yes |
|
Destination server is different from where you performed the backup |
Yes |
|
Restore Contents |
|
|
Entire Database |
Yes (with FSBasedBackupSet) This restore operation includes the database and the log files. |
|
Individual Databases, Schema, and Tables |
Yes (with DumpBasedBackupSet) |
|
Recover Options |
|
|
Recover to the current time |
Yes |
|
Recover to a point in time |
Yes |
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.