Restore you database without having to create a new database or instance

Question

Hi,

We are upgrading our SonarQube version. We have our plugin licenses attached to the instance (server) . We need to restore the database without having to create a new server or new database. If we create a new database or server , we would lose pur licenses and also our Power BI reports.

We would like to know how it would it would be possible to do the bacup restore in the same database?

Regards

Answer 1

You can directly restore your database over an existing database (you do not need to create another server or database)

The pg_restore command will overwrite data in your database. Make sure you have a backup before running this command.

pg_restore -U [username] -h [hostname] -d [dbname] -1 [backup_file]

But as a note:

if you restore the database you overrode the database this means that you lose all the difference between the backup and your existing DB

If your plugin licenses information also exists in the backup there will be no problem