Dumping a database

To dump a database,

1. Select a database in the Create & Drop Database dialog and click the Delete button. The Enter a dump file name dialog will appear.
2. Enter a file name and choose a destination directory.
3. Click the Save button.

At this step, the following command will be executed.

pg_dump database_name -Fc --file=dump_file_name

It is necessary to set the PostgreSQL Directory item in the Preferences dialog properly for tkDerm to find the pg_dump file and execute the above command. See Section 14.4 ( page) for setting the item.

Caution : An error will occur when dumping a database on Tcl/Tk 8.5. Tcl/Tk 8.4 works fine when dumping a database.

Caution : The dump file doesn't contain the encryption algorithm nor the encryption key. You will be prompted for this information when restoring the database.