we have upgraded our omero server from 5.5.1 to 5.6.1. It worked fine it seems.
For tests purposes, we usually dump the DB and I restore it locally on my computer using documentation’s instructions!
I do that on a dedicated VM (Debian 10.3, postgresql 11.7, fresh install)
Since we moved to 5.6.1 I have the following issue (one dump tested only but several times):
sudo -u postgres pg_restore -Fc -d omero_db omero.xxx.pg_dump
Error message at the very start of restoration locally:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 7; 2615 2200 SCHEMA public postgres
pg_restore: [archiver (db)] could not execute query: ERROR: schema “public” already exists
Command was: CREATE SCHEMA public;
Except that it went fine and the DB seems to work properly.
Can you help me in understanding the problem?
Do I have to worry?