Error 1012 - Access role issue for logical replication

Error Code 1012
Applies To All database Sources
Category Communication
Error Message Text(s) - FATAL: User must be a superuser or have the Replication or RDS_replication role to start walsender.

- FATAL: User must be a superuser or have the Replication role to start walsender.

Potential Causes

  • The username or password is incorrect.

Suggested Actions

  • Grant the rds_replication role to the database user:

    1. Log in to the database as a user with the rds_superuser role.

    2. Run the following command:

      GRANT rds_replication TO <database_username>;
    
  • Invite another team member with the required privileges to set up the Pipeline. Read Inviting and Moderating Team Members.


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Aug-23-2021 1.70 New document.
Last updated on 22 Sep 2021