Overview - PostgreSQL iDataAgent

Table of Contents

Introduction

The PostgreSQL iDataAgent is designed to efficiently manage and protect business critical data in PostgreSQL databases. You can use this iDataAgent to backup and restore the entire PostgreSQL server or individual databases. If necessary, you can also restore individual tables.

Key Features

The PostgreSQL iDataAgent offers the following key features:

Wide Range of Backup and Restore Operations

PostgreSQL iDataAgent provides the flexibility to backup the PostgreSQL databases in different modes and restore them in minimal time. You can perform a full or log backups of the entire PostgreSQL server or individual databases or archive logs at any point of time.

The following section describes the backups and restores that can be performed in different modes:

Backup and Restore Entire PostgreSQL Server

This iDataAgent provides the ability to restore an entire PostgreSQL Server. All the databases that reside on a source server can be restored on to a destination server.

In addition to performing backup and restores of databases, this iDataAgent performs database and log backups like any other database iDataAgent and effortlessly restores all the databases in a PostgreSQL server.

Backup and Restore Selective Individual Databases

You can use the CommCell Console to create user-defined subclients and distribute some of the database content for dump based backups. Distributing the client data using subclients in this way can help improve backup performance by organizing the workload on the client into logical groupings. While creating user defined subclients for dump based backup data, you can also choose selected object list. This option allows you to save time while restoring this subclient's data.

You can either define an individual database or a group of databases as subclient data and perform backup and restores.

Backup Logs

You can perform backups of only the logs in the PostgreSQL server. Log files are generated for each transaction made to the data files in the database. These log files can be used to recover the database transactions that have been lost due to an operating system or disk failure. You can apply them to the File System backup to recover the entire PostgreSQL server to a specific point-in-time.

Restore Database Tables

This iDataAgent allows you to restore and recover individual database tables to the same database or to another database. While restoring a dump based backup, you can select the Table View from the browse options to view all the tables in a database. During the restore operation, you can select individual tables from the list of database tables in a tree view from browse window and restore them to a destination location.

Restore Databases to a Point-in-Time

You can restore and recover an entire PostgreSQL server to a point in time for a File System Based Backup. A point in time restore job allows you to restore your PostgreSQL server to a specific point in time, and, typically, this point in time would be just before an undesired transaction, corruption, or update to your database.

Efficient Job Management and Reporting

You can view and verify the status of backup and recovery operations from the Job Controller and the Event Viewer within the CommCell Console. You can also track the status of the jobs using Reports, which can be saved and distributed. Generate reports for different aspects of data management. Customize the reports to display only the required data and save them to a specific location in different formats. For example, you can create a backup job summary report to view the completed backup jobs.

You can schedule, generate and send the Reports via email without user intervention. 

Block Level Deduplication

Deduplication provides a smarter way of storing data by identifying and eliminating the duplicate items in a data protection operation.

Deduplication at the data block level compares blocks of data against each other. If virtual machines contains blocks of data that are identical to each other, block level deduplication eliminates storing the redundant data and reduces the size of the data in storage. This dramatically reduces the virtual machine backup data copies on both the disk and tapes.

Terminology

The following terminology is used by this product:

Client

The computer in which the iDataAgent is installed and contains the data to be secured.

Instance

The PostgreSQL database to be used for the backup and restore operations.

BackupSet

A backupset is a logical grouping of subclients. This iDataAgent creates backup sets by default while creating an instance.

Dump Based BackupSet

A dump based backupset contains selected individual or a group of databases herein referred as dumps.

File System Based BackupSet

A file system based backupset contains an entire PostgreSQL server which includes all the databases and logs.

Subclient

The PostgreSQL data to be backed up.