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 or Tar archive.
Name pattern
Set the name for the output file. You can use {server}, {database}, {date} tags.
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.