- Plesk for Linux
- Restoring a backup in Domains > example.com > Backup manager finishes with the following warning:
PLESK_ERROR: pg_restore: WARNING: no privileges were granted for "pgdbtable"
pg_restore: WARNING: no privileges were granted for "pgdbtable"
WARNING: errors ignored on restore: 108
pgdbtabletable is owned by another user.
- #PPPM-8670 "The PostgreSQL database no longer fails to be restored from a backup if the database has objects owned by any database user."
- Plesk Obsidian 02 July 2018 (fixed as PPP-36922, Linux)
If update is not possible for some reason you may try the following
As a workaround, it is possible to perform restoration of such database via the command line:
Connect to the server via SSH
- Restore the table on behalf of superuser with the following command as an example:
# psql databasename -U postgres < pqsqldumpfile.sql