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:
'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:
The pg_dump command will require a password after connecting to the postgres server. There are 3 ways to enter the password:
- After executing the command, you will be prompted for the password which you will be able to type in at the command line.
- pg_dump will look for the environment variable PGPASSWORD. If you store the database password here, pg_dump will use it. This method isn't recommended as it's the least secure.
- Store the password in pgpass.conf. The location of this file is %APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile)
This method is considered most secure as you can set permissions on the file.
Help... I don't know the details of my database server!
The last line contains all the information you need to connect to your database.