Error Restoring the repository database

[djakubiak]

Hello,

When I restore the backup of repository database on a clean server, I have this message :

pg_restore: error : could not execute query: ERROR: "the “public” schema already exists"

The command was : CREATE SCHEMA public;

What coud I do to continue the restore ?

Best Regards

[djakubiak · Accepted solution]

Hello Albert,

In addition, I had to change the owner of the QSR database with pgAdmin and put qliksenserepository.

Best Regards.

David