Load Dump Dialog Help
This wizard serves to load a database dump. Valentina studio uses the same wizard to load dump for different database engines. If some database provides additional dump options, the wizard shows them on the separate page.
Type
Valentina Studio provides the ability to load dump in the SQL format for all supported database engines.
PostgreSQL accepts more dump types:
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 the directory.
SQL – Select this option if dump contained in the single file with SQL script.
Options
PostgreSQL database engines are provides advanced dump options:
PostgreSQL dump options:
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
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
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 an error occurs.
Verbose – Select if the loading process should be logged.
Dump utility version – version of the pg_restore to load a dump. The drop-down menu allows the user to manage versions of the pg_restore utility. Detailed description of version management is described here.
Source File
At this page, you should define a source file that will contain the dump.
Progress
At this page you can see loading progress. If loading dump for the particular database can tell amount of executed queries this number will be shown on this page.
If loading performs with errors this will be shown on the page. In this case user can make forced stop.
Result
If loading completed successfully the wizard will show appropriate message on the last page.
Otherwise the list of errors will be shown.
On the page only first 100 errors can be listed. It is a restriction for a
GUI performance. All other you can save into the file.