How to restore from pgsql backup

Hey there.

Nothing with regards to the backup/restore is SonarQube specific – you might want to follow a guide like this:

Upgrading SonarQube is a separate activity.