# 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.

×

Loading...