This is a guide for PostgreSQL databases only.

The program used to dump the database is called pg_dump.exe, a copy of it comes with the ContinuaCI Server installer and can be found in the %InstallDirectory%\Server\PostgreSQL\bin, the default location is C:\Program Files\VSoft Technologies\ContinuaCI\Server\PostgreSQL\bin.

pg_dump.exe has many options, the ones we use are the following:

 

%PGROOT%\pg_dump.exe

 

-h %DBSERVER% -p %DBPORT% -U %DBUSER% -F p -b -v -f %BACKUPDIR%\%BAKUPFILENAME% %DBNAME%