postgresql - Postgres subscription is not enabling

Question

I am on cluster of postgresql server where we get user for time limit, there is one already created subscription show it disabled, I want to enable it, but it is created by other user, even I become superuser but it is not enabled by using following command

ALTER SUBSCRIPTION mysub ENABLE;

I get following error

ERROR:  must be owner of subscription wildcards

I changed my role to superuser but it still can't enable it. How can I enable this service, as I suspect it was disable due to up-gradation of slave from postgresql 11 to 12 version. What roles are usally required to ENABLE subscriptions. I am using SET ROLE command to be superuser. Do I need to run ALTER USER command?

question from:https://stackoverflow.com/questions/65939844/postgres-subscription-is-not-enabling

Answer 1

After doing a lot things and wasting two days I got following method. First in my subscription user name is visible so use following command to change user.

grant {your_user_name} role to current_user

Now connect to that DB and Alter your subscription but instead of Enable you have to delete and recreate it, but remember you must have master credentials. This work and these all are commands of postgresql and I got help from its documentation, I don't know why it aws rds postgres is not postgresql.