WORK AROUND:
1. Login to the PostgreSQL on RDS with master user account and create the SharePlex user manually
Example:
CREATE ROLE splex with password 'splex' login;
GRANT rds_superuser TO splex;
grant connect on database xxx to splex;
2. Run pg_setup -p <port#> and when asked for to create a new SharePlex user, enter n and use the pre-created splex username
Would you like to create a new SharePlex user ? [y] : n
NOTE: Since the administrator, 'postgres', does not have the superuser role.
NOTE: The existing SharePlex user should have access privilege to database 'xxx'.
NOTE: PostgreSQL setup will try to grant other roles and privileges to the SharePlex user if available.
Enter the name of the existing SharePlex user : splex
Enter the password for 'splex' :
Completed SharePlex for PostgreSQL database configuration
SharePlex User name: splex
Database name: xxx
Target specification in SharePlex configuration: r.xxx
3. Login as schema owner for tables that you want to replicate to PostgreSQL on RDS
For example, to test a table owned by scott
login as scott on PostgreSQL on RDS
grant usage on schema scott to splex;
grant all privileges on all tables in schema scott to splex;
commit;
STATUS: This issue will be addressed in future release of 9.x