...
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 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:
Code Block |
---|
pg_dump.exe |
...
-h |
...
localhost -p |
...
9001 -U |
...
postgres -F p |
...
-f |
...
C:\continua_backup.bak ContinuaCI |