Issue Cannot restore PostgreSQL database (must be member of role "postgres")

[oldrichsveda]

Hi, I was migrated Plesk to new server, but on one domain I have PostgreSQL database that cannot be migrated. Any suggestions?


Warning: Restore domain "XXXX.cz"
Unable to find a service node by service IP address 'XX.XX.XX.XX'
Warning: Restore domain "XXXX.cz"
Failed deployment of database backoffice (domain XXXX.cz)
Warning:
Errors occurred during deployment of database content. Not all content may be restored. Resolve the errors if required or try to restore the content manually from the archive: databases/backoffice_2[dbdump]: backup_dbdump_2007290319.tgz
Warning:
Execution of /usr/lib/postgresql/9.6/bin/pg_restore -d backoffice -p 5432 --use-list /tmp/pmm-ru-udb-dump-n0PCuw/backup_dbdump_2007290319.list /tmp/pmm-ru-udb-dump-n0PCuw/backup_dbdump_2007290319 failed with return code 1. Stderr is pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 1449; 1255 97880 FUNCTION f_unaccent(text) postgres pg_restore: [archiver (db)] could not execute query: ERROR: must be member of role "postgres"

Command was: ALTER FUNCTION public.f_unaccent(text) OWNER TO postgres; pg_restore: [archiver (db)] Error from TOC entry 206; 1259 73031 TABLE rn_adresni_misto backoffice_web pg_restore: [archiver (db)] could not execute query: ERROR: type "public.geometry" does not exist

.....

 

[oldrichsveda]

Does anyone know how to deal with this Plesk bug?