Can't CREATE PUBLICATION on RDS Postgres v13

0

RDS Postgres v13.7 I have referred to the official documentation 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.

1回答
0

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;
AWS
回答済み 1年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ