Certificate Hub database requires restoring the database.
Follow the steps below in the same Certificate Hub version used when Backing up the state of Certificate Hub.
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 generated in Backing up the state of Certificate Hub.
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.