PostgreSQL

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	Create a consistent dump of databases using pg_dump Create a table object list during backup (optional) pg_dump using parallel jobs Perform backups of global objects metadata using pg_dumpall	Traditional	Full	DumpBasedBackupSet	Database level restore Schema level restore Table level restore Restore to another instance on cloud Restore to an onpremise instance	Cloud Apps
Backup of databases from an on-premise using pg_dump utility	Create a consistent dump of databases using pg_dump Create a table objectlist during backup (optional) pg_dump using parallel jobs Perform backups of global objects metadata using pg_dumpall	Traditional	Full	DumpBasedBackupSet	Database level restore Schema level restore Table level restore Table level restore to auxiliary database Restore dump to disk Cross instance restore Cross machine restore	Creating a PostgreSQL Subclient to Back Up Specific Databases Using Parallel Jobs to Dump the PostgreSQL Database Restoring PostgreSQL Databases from a DumpBased Backup
File based online data backup with WAL files	Combine file system-level backup of data files and WAL files to restore databases to a consistent level by replay of logs Perform full backup of data directory, tablespace directories, config files and WAL files Incremental backup of WAL files	Traditional	Full Incremental logs	FSBasedBackupSet	Full instance restore Point in time restore Application-Free Restore Redirect restore Cross instance restore Cross machine restore	Configuration - PostgreSQL iDataAgent
Snapshot based online data backup with WAL files, followed by file system backup copy	Create application consistent storage snapshots while the database is in the backup mode Copy snapshots to a disk at file level using multistream backup copy option Proxy client to mount snapshot during backup copy (optional)	IntelliSnap	Full Incremental logs	FSBasedBackupSet	Full instance restore from snapshot Full instance restore from backup copy Revert restore Point in time restore Redirect restore Instant Clone Recovery Cross instance restore Cross machine restore	Getting Started with the PostgreSQL Agent
Block level backups using snapshot based online data backup with WAL files, followed by file system backup copy	Create application consistent storage snapshots while the database is in the backup mode, with efficient block storage mechanisms to speed up the backups Faster backups, quick granular restore and improved recovery points with frequent backup cycles Copy snapshots to a disk at file level using multistream backup copy option Proxy client to mount snapshot during backup copy (optional)	Block level	Full Incremental data Incremental logs Synthetic full	FSBasedBackupSet	Full instance restore from snapshot Full instance restore from backup copy Revert restore Database level restore Schema level restore Table level restore Point in time restore Redirect restore Cross instance restore Cross machine restore Instant Clone Recovery Volume level multisteam restore (only clients that use the latest version of indexing)	Block-Level Backups
Live Sync replication	Continuous synchronization of master server to standby server by restoring logs from the backups taken for master	Traditional	Full Incremental logs	FSBasedBackupSet	As applicable for traditional backups of FSBasedBackupSet	Live Sync Replication
Backup from Standby Server	File based online backup of data and WAL files from standby server Offloads backup activity from production server	Traditional IntelliSnap	Based on the backup type selected	FSBasedBackupSet	Based on the backup type selected	Back Up from Standby Server
Backup from Replication Cluster	To back up data from standby server. Automatically, backs up data from new standby server incase of a failover. If no standby server is online, the backup is performed on the master server. Provides integration with Native replication, EFM, Repmgr and Patroni.	Traditional IntelliSnap Block Level	Based on the backup type selected	FSBasedBackupSet	Restore as a cluster Restore from single node to cluster Restore from cluster to single node	Cluster Backup Support for PostgreSQL