Export Data
One function of the utility vovdb_util
is to export the database
into jobs data files. The exported files are saved in the
vnc.swd/data/dump directory.
% vovproject enable vnc
vovdb_util
vovdb_util: Usage Message
DESCRIPTION:
Utilities for use with the VOV database.
USAGE:
% vovdb_util <COMMAND> [COMMON OPTIONS] [OPTIONS]
COMMANDS:
backup <dest> -- Backs up the VOV database to the specified
destination. This command must be run on
the same machine as the database. If the
destination exists it must be empty.
The database must also be running.
clearcfg [-noconfirm] -- Resets the VOV database configuration to
the initial, unconfigured state. Pass
-noconfirm to skip confirmation.
exportconfig <fileout> -- Exports VOV database configuration
properties DB_* to obfuscated file.
exportpasswords <fileout> -- Exports VOV database passwords
from project to obfuscated file.
help -- Shows help information.
importconfig <filein> -- Imports VOV database configuration
properties DB_* from obfuscated file.
importpasswords <filein> -- Imports VOV database passwords
from obfuscated file to project.
configure [-v] [-reset] [-noconfirm] <host> <root> [<port>]
-- Sets the host, root data path, and port for
the VOV database. Pass -reset to overwrite
existing settings. Pass -noconfirm to skip
confirmation.
showcfg -- Prints out current VOV database
configuration.
startdb -- Starts the VOV database. Will restart a
running database.
status -- Prints current VOV database status.
stopdb -- Stops the VOV database.
upgrade [-noconfirm] [-sdb sourcedir] [-spgsw pg_software_dir]
-- Upgrades the VOV database to use the newest
version of the PostgreSQL engine.
Options:
-noconfirm to skip confirmation
-sdb to specify path to Source database
-spgsw path to older version of PG
binaries compatible with Source database
The following commands are only supported for Accelerator and Monitor.
dump [-pre201509] [-start <YYYYMMDD>] [-end <YYYYMMDD>]
-- Generate data files, optionally limited to
the start and end times specified. Pass
-pre201509 to dump the database that was
used prior to 2015.09 (or beyond.)
trim <YYYYMMDD> -- Deletes data prior to the given date.
COMMON OPTIONS:
-v -- Increase verbosity.
Database Export
Database export is done using the vovdb_util dump command. Pass the optional -start YYYYMMDD and -stop YYYYMMDD to restrict the dump to after the specified start date and before the specified end date.
Dump Pre-2015.09 Databases
If updating Accelerator from a version prior to 2015.09, it is possible to pass the -pre201509 option to vovdb_util dump to generate data files from the old database. This can be used to save old data if the original data files are no longer present.
Exported Jobs Directory
The vnc.swd/data/dump/jobs directory contains the exported jobs data. The dumped data files can be loaded into a new database using the vovsql_load_jobs utility.