Online Documentation for SQL Manager for PostgreSQL

Selecting backup options

Specify options for the backup and select the backup type: full or incremental.

Utility version

Select the exact server version.

Output folder

Set the target directory to write the output. This option is mandatory.

Output format

Selects the format for the output: plain (the same layout as the source server's data directory and tablespaces) or tar (TAR files).

Compression level

Set the backup compression level for TAR format. Gzip compression is used.

Maximum transfer rate (kb/s)

Set the maximum transfer rate at which data is collected from the source server. This can be useful to limit the impact of pg_basebackup on the server. Values are in kilobytes per second.

Include transaction logs

Enable this option to include the required WAL (write-ahead log) files in the backup and select the parameter: fetch (the write-ahead log files are collected at the end of the backup) or stream (log data is written while the backup is being taken).

Backup label

Set the label for the backup. If none is specified, a default 'pg_basebackup base backup' value will be used.

Incremental

Select this option to create an incremental backup.

Folder with backups

In case of incremental backup select the folder for the backup files.

Click the Next button to proceed to the Running cluster backup or Selecting incremental backup starting point step of the wizard.