Hi,

I’d like to assign the pg_monitor role to a user I created for myself in a managed PostgreSQL database. The problem I’m encountering is that neither db nor doadmin have the necessary permissions to grant this role to a new user.

db=> GRANT pg_monitor to doadmin with ADMIN OPTION;

ERROR: must have admin option on role "pg_monitor"

I’d like to use an external tool to monitor several database metrics instead of DigitalOcean’s built-in method.

Other managed offerings provide operators with the means to assign this role, how about DigitalOcean?