Things to know before you protect PostgreSQL instances and databases
Protection plans can be used to predefine backup policies which are then used by others to protect their data. The following table describes the permissions with which PostgreSQL non-root database user should be created:
Table: User Privileges
User | Privileges |
|---|---|
Protection and Recovery | Superuser |
To set the database user privileges, run the following command at PostgreSQL command line:
ALTER USER "username" WITH SUPERUSER;