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 recommend are the following:
| Option | |
|---|---|
| -h | '127.0.0.1' if you're on the same machine as the Continua database server |
| -p | 9001 is the default port we use when installing Continua. |
| -U | postgres is the default username when installing Continua |
| -F p | This outputs the database in plain text which equates to SQL commands |
| -f <backup_filename> | The full path and file name where the database backup will be written to. |
The final options is the database name which is ContinuaCI.
The final command then will look something like this:
pg_dump.exe -h localhost -p 9001 -U postgres -F p -f C:\continua_backup.bak ContinuaCI