Online Documentation for SQL Manager for PostgreSQL

Setting additional backup options


This step offers some additional options that may be useful for the database backup operation.

 

Backup Database - Setting additional backup options

 

Structure options

CheckBox Add create database command

If this option is selected, the CREATE DATABASE statement will be included into the backup script.

 

CheckBox Add drop object commands

If this option is selected, the DROP statements will be added for database objects.

 

CheckBox Don't use $ quoting

This option disables dollar-quoting in the backup script.

 

CheckBox No privileges

This option disables privilege allocation for database objects in the script.

 

CheckBox Don't set object ownership

This option disables object ownership statements for database objects in the script.

 

CheckBox Use set session authorization

If this option is selected, the currently set session authorization is used.

 

Data options

Specify the method that will be used to backup data.

RadioButton Data as COPY statements

RadioButton Data as INSERT statements

 

CheckBox Disable triggers

Select this option to disable triggers for the backup session.

 

CheckBox Dump table OIDs

If this option is selected, table OIDs (object identifiers) will be dumped as well.

 

CheckBox INSERT with column names

If this option is selected, column names will be included into the INSERT statements.

 

Advanced options

CheckBox Compress file

If this option is selected, the backup file will be compressed to the extent specified using the Compress level control.

 

CheckBox Dump BLOBs

If this option is selected, BLOBs (binary large objects) will be dumped as well.

 

CheckBox No setting tablespace commands

With this option, all objects will be created in whichever tablespace is the default during restore.

 

CheckBox Don't add table access commands

This option allows not to output commands to select table access methods. With this option enabled all objects will be created with the default table access method during restore.

 

Compress level

This control allows you to set the compression level for the backup file. Move the slider between the 0 and 9 threshold values to select the required compression level value within this scope.

 

When you are done, click the Next button to proceed to the next step of the wizard.