Return
-
Title
Pg_setup on RDS returns error with administrator does not have the superuser role -
Description
When running pg_setup on PostgreSQL on RDS, it returns below error when choosing to create a new SharePlex user
./pg_setup -p 9001Welcome to SharePlex for PostgreSQL setup.This process creates the SharePlex tables, login and user accounts needed to runSharePlex replication.To create these items, we must connect to the database as an Administrator.Enter the PostgreSQL DSN name or connection string [] : xxxxEnter the PostgreSQL Administrator name : postgresEnter the password for the Administrator account :NOTE:User 'postgres' does not have the superuser role.Enter the replication target database name : testWould you like to create a new SharePlex user ? [y] : yNOTE: Since the administrator, 'postgres', does not have the superuser role.NOTE: It does not allow to add user to exisiting database./u01/jess/prod863/.app-modules/pg_setup:Exiting...
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.