Loading...

PostgreSQL

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.

Last modified: 1/3/2020 4:11:49 PM