Superuser privilege on Postgres for DMS
Hi, trying to perform a 0-downtime migration and I want to use the Railway database as the source for AWS DMS. However, replication is failing which I believe is because the user doesn't have superuser privilege from the source database.
I believe it's needed for some granular control over Write Ahead Logs.
Is this not possible with Railway's Postgres?
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html
For full-load plus CDC tasks or CDC-only tasks, grant superuser permissions for the user account specified for the PostgreSQL source database. The user account needs superuser permissions to access replication-specific functions in the source. For full-load only tasks, the user account needs SELECT permissions on tables to migrate them.
Using a PostgreSQL database as an AWS DMS source - AWS Database Mig...
Use a PostgreSQL database as a source for AWS DMS.
2 Replies