We have Sonarqube 7.1 Developer edition that was installed manually on a server using PostgresSQL 11 a while back.We now need to migrate it to a new setup and have a few questions,
We need to rehearse the migration a few times to ensure it works and iron out any issues as we are not allowed access to the dbcopy tool under current developer licence. If we backup the source database from one server and restore it to another does this mean the licence will be running in 2 locations at once and will this cause any issues? If there are licence issues what options do we have, can we use a temporarily licence on the destination server until such time as we really intend to cutover?
Is a postgres database backup via “pg_dumpall > filename.sql” and restore via “psql <DATABASE_NAME> -f filename.sql” sufficient or are other steps required?
The documentation only covers backup and restore of the database, what about backup and restore of the metadata on disk eg: config/plugins/etc, is there detailed documentation on what needs to be backed up and restored and any caveats around it?