- Plesk for Linux
- The restore process at Plesk > Domains > example.com > Backup manager finishes with the following warning:
PLESK_ERROR: pg_restore: WARNING: no privileges were granted for "example"
pg_restore: WARNING: no privileges were granted for "example"
WARNING: errors ignored on restore: 108
exampletable is owned by another user.
As of now, this is expected behavior. All the objects in a database should be created under database users assigned to it in Plesk only. However, this behavior is going to be improved in scope of #PPPM-8670.
As a workaround, it is possible to perform restoration of such database via the command line:
Log in to Plesk server using SSH.
- Restore the table on behalf of superuser with the following command as an example:
# psql database_name -U postgres < dumpfile.sql