Can't CREATE PUBLICATION on RDS Postgres v13

Question

RDS Postgres v13.7
I have referred to the [official documentation](https://repost.aws/knowledge-center/rds-postgresql-use-logical-replication) with no luck.

I have set `rds.logical_replication` to 1 and
`SELECT name,setting FROM pg_settings WHERE name IN ('wal_level','rds.logical_replication');`
returns
```
          name           | setting
-------------------------+---------
 rds.logical_replication | on
 wal_level               | logical
```
Nevertheless,
```
CREATE PUBLICATION aurora_migration FOR ALL TABLES;
```
always returns
```
ERROR:  permission denied for database mydb
```
I have tried both with the admin user (which has role rds_superuser) and with a new role that has rds_replication and both usage on the pubic schema as well as SELECT rights on all tables.

I'm hoping I overlooked something simple.

AWS-JohnH · Answer

Hi,

Do you have the same error if you ALTER the owner of the database to your rds_superuser first? 
Something like:

```
 ALTER DATABASE mydb OWNER to my_rds_superuser;
```

Can't CREATE PUBLICATION on RDS Postgres v13

Add your answer

Relevant content