07. Data Backup and Restore on Windows

Before you begin

Please shut down qTest Manager and qTest Sessions services

Back up data for qTest Manager

Restore data for qTest Manager

Back up data for qTest Manager

Back up databases

You will need to back up qTest Manager database and the integration (Poseidon) database following the steps below:

  1. To make sure that you back up the correct databases, access to the installation directory of qTest Manager. Open file qtest.config and check the database names
    qtestconfig - DB names
  2. Access to PostgreSQL server. Open the Command Prompt. Access to the bin directory under your PostgreSQL's installation directory (eg: C:\Program Files\PostgreSQL\9.5\bin)
  3. Execute the following command for both of the databases
    pg_dump.exe --host=[postgresql_host] --port=[postgresql_port] --username=[user] --password --dbname=[database_name] > [file_name].sql
    		

Back up attachments

Back up qTest Manager's attachments stored in the directory as defined in attachmentDirectory in qTest.config file

qtestconfig - attachment dir

Restore data for qTest Manager

You will need to restore data to qTest Manager database and the integration (Poseidon) database following the steps below:

  1. To make sure that you restore to the correct databases, access to the installation directory of qTest Manager. Open file qtest.config and check the database names
    qtestconfig - DB names
  2. Access to PostgreSQL server. Open the Command Prompt. Access to the bin directory under your PostgreSQL's installation directory (eg: C:\Program Files\PostgreSQL\9.5\bin)
  3. Use the backup files and execute the following command for both of the databases
    psql.exe --host=[postgresql_host] --port=[postgresql_port] --username=[user] --password --dbname=[database_schema] < [backup_file].sql