To restore the Certificate Hub database, follow the steps below in the same Certificate Hub version used when Backing up the database.
Restoring the configuration
Reapply the following configurations.
- Name of the PostgreSQL Database
- External database port
- Database User Password
- CA Certificate(s)
- SSLMode for the PostgreSQL external database
- Database User Name
Restoring the database contents
Restore the Certificate Hub database using the Database Management System (DBMS) tools.
Restoring the database encryption key
Run the following command to restore the database encryption key.
sudo dbctl.sh restore -n certhub --backup-file <backup-file>Where <backup-file> is the path of the backup file.
Before running this command, you can ignore or delete the user-creation and role-update jobs in ERROR state.
Completing the database restoration
Redeploy Certificate Hub to make effective the restoration of the database encryption key.