Omero-server 5.6.1 - DB restoration - Error while processing TOC

Hi,
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):
Command:

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?

Best regards,
Christophe

Hi Christophe,

this is caused by a change between PostgreSQL versions. As long as the rest of the restore completed and there were no further errors printed, things are fine.

See https://www.postgresql.org/message-id/20849.1541638465%40sss.pgh.pa.us for more context.

~Josh

1 Like

Thank you, Josh, for the quick answer and the context provided :slight_smile:

Best regards,
Christophe

PS: for some reasons the pg_dump stayed in version 10 on our server which explains the issue I guess. It’s getting fixed as I write!

1 Like