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%