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?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Hi there,
As far as I know, DigitalOcean Managed PostgreSQL doesn’t allow granting system roles like pg_monitor, since users don’t have full superuser privileges. It seems those roles are reserved for internal management and stability reasons.
You could still use built-in metrics or query views like pg_stat_activity for monitoring. If you’d like more flexibility, it might be worth sharing the request with the product team here: https://ideas.digitalocean.com/
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.