toluaina / pgsync

Postgres to Elasticsearch/OpenSearch sync
https://pgsync.com
MIT License
1.16k stars 180 forks source link

RDS replication slot not creating asking for super user #475

Closed ChiragGangwani closed 1 year ago

ChiragGangwani commented 1 year ago

PGSync version: 2.5.0

Postgres version: 12

Elasticsearch version:

Redis version: latest

Python version: 3.10

Problem Description:

While running bootstrap command it showing that user needs to be super user for creating replication slot but i have my db in rds how to grant him access for replication because we have publication and subscription in rds.

Error Message (if any):

'PG_USER "sorted" needs to be superuser or have permission to read, create and destroy replication slots to perform this action.'