> Software > Protect > Databases

PostgreSQL

You can use the Commvault software to back up and restore PostgreSQL databases.

Note

Commvault supports pgvector extension for PostgreSQL. The destination instance should also have pgvector extension in case of Out-of-Place restore.

Backups

Data You Can Back Up

  • Database

  • Transaction logs (with FSBasedBackupSet)

Backups You Can Perform

  • Full backups

  • Incremental backups (transaction log backups with FSBasedBackupSet)

When You Can Perform Backups

  • On a schedule: The backup plan that you assign manages scheduled backups

  • On demand: You can perform on-demand backups at any time

Restores

Data You Can Restore

  • Entire instance: The database and the log files using FSBasedBackupSet

  • Individual databases, schema and tables: Using DumpBasedBackupSet

Backups You Can Use for Restores

  • The most recent backup: For example, restore the most recent backup to its original location

  • A backup from a specific date: For example, restore data to a point in time before it became unusable

  • Backups from a date range: For example, restore data that was accidentally deleted

Destinations You Can Restore To

DumpBasedBackupSet:

  • (In place): Restore data to the server that it was backed up from

  • (Out of place): Restore data to the following destinations:

    • A different server or instance

    • Restore data to the server that it was backed up from

    • You can restore PostgreSQL databases from on-premise to cloud such as Alibaba Cloud, Amazon Web Services, Azure and Google Cloud.

    • Stage the database dump to disk

FSBasedBackupSet:

  • (In place): Restore data to the server that it was backed up from

  • (Out of place): Restore data to the following destinations:

    • A different server or instance

    • You can restore PostgreSQL databases from on-premise to server hosted in cloud VM.

PostgreSQL Portability

You can perform the following cross-server restore operations.

Source

Destination

Windows

Linux

Windows

Yes

No

Linux

No

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.

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

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

Restoring PostgreSQL Databases from a FSBased Backup

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 indexing v2)

Block-Level Backups

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

PostgreSQL in a Kubernetes Cluster

To back up and restore a PostgreSQL app running in a Kubernetes cluster.

PostgreSQL in a Kubernetes Cluster

PostgreSQL in a Docker Cluster

Configure and run dump-based backups for PostgreSQL.

PostgreSQL in a Docker Cluster

Application-Aware Support for PostgreSQL

To back up and restore PostgreSQL databases with application-aware protection on traditional hosts.

Application-aware protection
×

Loading...