Error 1012 - Access role issue for logical replication

Last updated on Oct 26, 2022
Error Code 1012
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
Sep-05-2022 NA Brought this page under its respective Source documentation folder.
Aug-23-2021 1.70 New document.

Tell us what went wrong