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.
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 AI-native businesses
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.
Start building today
From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.
