Starting in the Plugin for PostgreSQL v12.3 we have added support for point-in-time recovery (PITR) as well as perform Incremental Backups, also known as continuous archiving.
Please see the Plugin for PostgreSQL v12.3 user guide to prepare your PostgreSQL Server to support continuous archiving and PITR.
The PostgreSQL Plugin supports the following backup types:
- Full Database Cluster: This option backs up all the databases within the cluster in the selected backup format. It also includes a backup of Global Objects, which are in the form of a Plain-text Script file,regardless of the backup format specified. The plug-in automatically includes the configuration files when the database cluster is selected; however, you can exclude it from the backup if applicable
- Individual Database/Table: This option backs up selected databases or tables in the selected backup format. You can use it to back up databases that are updated more frequently than others or use it as a source when creating test environments. This option does not include Global Objects when the databases or tables are backed up individually
- Global Objects Only: This option backs up only the Global Objects, which you can use to back up the updates made to the database users, groups, and access permissions.
- Configuration Files Backup: You can back up the configuration files with any of the preceding backup types, or separately. The following files are included when you select this option:
▪ postgresql.conf: This file is the primary server configuration file that contains all the parameter
settings and directives.
▪ pg_hba.conf: This file is the host-based authentication (HBA) or client authentication file.
▪ pg_ident.conf: This file stores ident maps, excluding sameuser, and is used for ident-based
This backup type is similar to a file-system backup. You can use it to restore corrupt or lost configuration
files, or to restore the cluster settings to a different server.
The latest version of the Plugin for PostgreSQL can be downloaded from the following location: