Online Documentation for SQL Backup for PostgreSQL

Defining backup file options


At this step you can set options for the backup result file.

 

File format

Select the output file format: Plain-text SQL script, Custom gzip archive file, Tar archive or Directory-format archive file.

 

Name pattern

Set the name for the output file. You can use {server}, {database}, {date} tags.

 

Backup database - Specifying backup file related options

 

Encoding

Use the drop-down list to select the character set encoding for the output file.

 

Compression level

This control allows you to set the compression level for the backup file. The values are ranged 0-9. Select 0 if no compression is needed.

 

Number of jobs

This options is only available for directory-format backup files and sets the number of executing threads to increase backup speed.