Step 3: Configure Your PostgreSQL Target Database - Database Migration Guide
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Step 3: Configure Your PostgreSQL Target Database

  1. If the schemas you are migrating do not exist on the PostgreSQL database, then create the schemas.

  2. Create the Amazon DMS user to connect to your target database, and grant Superuser or the necessary individual privileges (or use the master username for RDS).

    CREATE USER postgresql_dms_user WITH PASSWORD 'password';
ALTER USER postgresql_dms_user WITH SUPERUSER;

  3. Create a user for Amazon SCT.

    CREATE USER postgresql_sct_user WITH PASSWORD 'password';

GRANT CONNECT ON DATABASE database_name TO postgresql_sct_user;
GRANT USAGE ON SCHEMA schema_name TO postgresql_sct_user;
GRANT SELECT ON ALL TABLES IN SCHEMA schema_name TO postgresql_sct_user;
GRANT ALL ON ALL SEQUENCES IN SCHEMA schema_name TO postgresql_sct_user;