Scale up as you grow — whether you're running one virtual machine or ten thousand.

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.

Hi, I’m trying to implement logical replication on DO Managed DB Cluster. I was able to create Publication on my pub DB with doadmin user. But when i tried creating Subscription on my sub DB. It threw the following error:
ERROR: permission denied to grant role “pg_create_subscription” DETAIL: Only roles with the ADMIN option on role “pg_create_subscription” may grant this role.
Although, I’m using the doadmin user. But, still i can’t assign this role which is frustrating as it isn’t a super user and I don’t have access to postgres which is super user.
P.S: I created subscription on my local DB and it was working. So, nothing is off with the commands.
Aakash Singh
Aakash Singh
Frank Tufano
fullammo
4ae272398ee6445a9bf73f4cd632b5
eddie
Taha Aziz Ben Ali
Telmo Valverde
Alexandre Herlinvaux
52d4eff26a544eefb189e2005836b2