Create and Load PostgreSQL Dumps

Create Dump

pgdump

To export the database in PostgreSQL, execute the following command:

pg_dump -U <codebeamer_database_user> <codebeamer_database_name> > codebeamer_dump.sql

pg_dump -U <codebeamer_database_user> -h <postgresql_server_host> -p <postgresql_server_port> <codebeamer_database_name> > codebeamer_dump.sql

Exporting dump without binary data

If the binary data is stored in the database than exporting database without binary data is recommended:

pg_dump -U <codebeamer_database_user> -B --exclude-table-data=*_blobs <codebeamer_database_name> > codebeamer_dump.sql

pg_dump -U <codebeamer_database_user> -h <postgresql_server_host> -p <postgresql_server_port> -B --exclude-table-data=*_blobs <codebeamer_database_name> > codebeamer_dump.sql

The pgdump command produces a codebeamer_dump.sql file which can be compressed with zip, tar or tar.gz.

For more information about this tool please visit the offical site: https://www.postgresql.org/docs/11/app-pgdump.html

Import Dump

To import the exported postgresql dump, use the following psql command:

psql -U <codebeamer_database_user> <codebeamer_database_name> < codebeamer_dump.sql

psql -U <codebeamer_database_user> -h <postgresql_server_host> -p <postgresql_server_port> <codebeamer_database_name> < codebeamer_dump.sql

Obfuscate sensitive data

1. Create a copy of the codeBeamer system you want to obfuscate, if necessary.
2. Stop the codeBeamer test instance.
3. Run the following script against the test database obfuscate_data_postgres.sql. The following command can be used:
   

   psql -U <user> -h <host> -p <port> -d <your_db> -f ./obfuscate_data_postgres.sql

4. Dump the obfuscated database as described above.

Check the obfuscated database

1. After executing the script it is not possible to login to codebeamer because all user credentials (usernames and passwords) are removed.
   • Log in to the postgresql and execute the following commands to set all user password to '007':
     • create extension pgcrypto;
     • execute the following SQL command:
       

       update users set registrydate=null, passwd=encode(digest(concat('007', id, '700101010000'), 'sha512'), 'hex');

2. Delete the directories under /repository/docs.
3. Start codebeamer.
4. Login to codeBeamer with user-<user-id>/007. For example: user-1/007