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 objectlist during backup (optional)

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)

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

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 (indexing v2 client only)

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

Loading...