Loading...

PostgreSQL Databases

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 subclients 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 Admin Console 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 subclient.

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

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