- 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
This is expected behavior. All the objects in a database should be created under database users assigned to it in Plesk only. Plesk restores databases with permissions granted to such database users for security reasons.
As a workaround:
Log in to Plesk server using SSH.
Access Postgresql database server:
# sudo -u postgres psql
Grant database user membership of postgres role group:
# grant postgres to testuser;
Warning: The workaround may cause security issues thus it is highly not recommended using it. All the actions will be performed at your own risk.