Backup Database
Backup Database
(
) is an extremely important feature. As
with other computer programs, unforeseen hardware and software problems can cause
your PostgreSQL data to be lost. Therefore, it is strongly encouragted that backups
of the database be made frequently and regularly. This feature allows a convenient
way to perform database backups using the PostgreSQL built-in pg_dump utility.
The Database Backup Wizard
Selecting Backup Database opens a wizard page with seven options. Complete these
options and click Finish to start the backup operation.
-
Backup File. Enter the name of the
backup file to use, either by navigating to it with the Browse button or by typing
it in manually. If an existing file is used, the backup process will overwrite it.
To create a new file, either type the name here or open the browser and type it into
the appropriate window there.
-
Backup Engine. Enter the location
of the PostgreSQL backup engine (pg_dump.exe) here. The engine is used to
perform the backup operation. This is included in the PostgreSQL installation
and if the JDBC .jar has been entered (see Connection Settings), Komo will try to
locate it for you.
-
File Format. Komo can use two of the
four pg_dump output formats. The Custom format is recommended but .tar files can
have advantages, particularly on Unix systems. Select the desired backup file
archive format here.
-
With OIDs. Object Identifiers
(OIDs) have long been a part of PostgreSQL but their utility has been questioned
in recent years. Enabling this option is not recommended unless your database
makes specific use of OIDs (e.g., as indexes or keys).
-
Disable Dollar Quoting.
Dollar-quoting is a convenient coding format used in PostgreSQL functions. In
some specific circumstances it maybe desirable to have a database archive that
uses standard SQL syntax rather than dollar-quoting. This option may be enabled
if this is desired.
-
Verbose. Enabling this option,
which is recommended, causes a detailed log of the backup operation to be
presented upon completion of the process.
-
Ignore Version. This option
causes version warnings to be ignored during backup operations. Some caution is
required when this option is used, as problems can occur with backing up
databases created with older versions of PostgreSQL or with using an older
version of PostgreSQL to back up a database created with a newer version. Review
of the relevant PostgreSQL documentation is recommended before this option is
used.