Switch to: V12V11V10V9V8V7V6V5

Load Dump [PostgreSQL] Dialog Help

Database Name

On this page you can set the name for a new database, that will be a target for the dumping.

PostgreSQL Load Dump Dialog - Database Name

  • New DB Name – The name for database, that will be created for loading dump.

Kind

On this page you can select the format of the dump.

PostgreSQL Load Dump Dialog - Kind

  • Custom or Tar – Select this option if dump contained in the tar-format, or in some else custom format.
  • Directory – Select this option if dump contained in directory.
  • SQL – Select this option if dump contained in the single file with SQL script.

Data

On this page you can select the kind of input data.

PostgreSQL Load Dump Dialog - Data

  • Structure Only – If selected, then the dump will contain information only about database structure.
  • Structure And Records – If selected, then the dump will contain information the database structure and all records.
  • Records Only – If selected, then the dump will contain information only about records in the database.

Option

Queries

PostgreSQL Load Dump Dialog - Queries

  • Include CREATE DATABASE statement – Select if the dump starts with CREATE DATABASE statement.
  • Clean before restore – Select if need to drop objects before create.
  • Single transaction – Select if need to load dump by single transaction.

Save

PostgreSQL Load Dump Dialog - Save

  • Owner – Select if no need to load object owners.
  • Privilege – Select if no need to load privileges.
  • Tablespace – Select if no need to load tablespaces.

Misc

PostgreSQL Load Dump Dialog - Misc

  • Disable triggers – Select if no need disable triggers on the target tables while the data is reloaded.
  • No data for failed tables – Select if no need to load data for failed tables.
  • Use SET SESSION AUTHORIZATION – Select if the dump contains SET SESSION AUTHORIZATION command.
  • Stop on error – Select if loading should stop when error occurs.
  • Verbose – Select if the loading process should be logged.

Location

On this page you can select the dump location.

PostgreSQL Load Dump Dialog - Location

  • Destination – The path to dump files.
  • File Encoding – The Ecoding of text in the dump file: UTF-8 or UTF-16