Quality Modeller Maintenance

1. Back up

Backup The Prostgres Docker Database:

Create a backup dump file:

Use the script found in the package folder to create a backup dump file:  utils/backup-postgres.sh 

Note: Using the script might require sudo privileges. The Test Modeller environment needs to be up and running in order to use the script.

Create a backup dump file and place it in package folder

sudo ./utils/backup-postgres.sh

Use -d option to create the backup dump file and place it in a different directory

e.g. /opt/curiosity/backups

sudo ./utils/backup-postgres.sh -d /opt/curiosity/backups

Backup The Postgres Database if it Lives Outside Docker

Open a new command window and enter the following command. Replace the parameters with your appropriate details:

pg_dump -h -p -U -W backup_[date].sql

Neo4J Backup

Backup the Neo4j Docker Database

Open a new command window and enter the following command. Replacing the parameters with your appropriate details.

docker exec -t testmodeller_graph bin/neo4j stop

docker exec -t testmodeller_graph bin/neo4j-admin dump –database=graph.db –to=- > neo4j_dump_date +%d%m-%Y""%H%M_%S.dump

2. Restore

Restore The Postgres Docker Database

Restore from a backup dump file:

Use the utils/restore-postgres.sh script found in the package folder to restore a backup dump file.

Note: Using the script might require sudo privileges. The Test Modeller environment needs to be down in order to use the script.

Use -d option to point to the backup dump file that was created using the backup command (e.g. /opt/curiosity/backups/postgres_dump_0103-20231904_36.sql)

sudo ./utils/restore-postgres.sh -d /opt/curiosity/backups/postgres_dump_0103-20231904_36.sql

sudo ./utils/restore-postgres.sh -d /opt/curiosity/backups/postgres_dump_0103-20231904_36.sql -l

Restore The Postgres Database if it Lives Outside Docker

Open a new command window and enter the following command. Replacing the parameters with your appropriate details.

psql -h localhost -d -U -f -W

Restore Neo4j

Open a new command window and enter the following command. Replace the parameters with your appropriate details:

bin/neo4j stop

bin/neo4j-admin load –from=/backups/graph.db/2016-10-02.dump –database=graph.db –force 

3. Change Database Password

Change Postgres Password

Change Postgres password in the corresponding docker container

sudo docker exec -it testmodeller_db psql -U admin postgres
alter user postgres with password 'new password';
\q

:server change-password