PostgreSQL database to Amazon RDS post-migration clean-up

Use DMS Fleet Advisor to inventory your source databases and discover other candidates to move to the cloud. For more information, see the DMS Fleet Advisor User Guide.

Learn more about Amazon RDS for PostgreSQL. For more information, see the Amazon Relational Database Service User Guide.

Sign in to the Amazon Web Services Management Console and open the Amazon DMS console.

In the navigation pane, choose Migration projects, and choose dm-project. On the Data migrations tab, choose Stop for Actions.

After Amazon DMS stops your data migration, choose Delete for Actions and confirm your choice.

Choose Migration projects, and choose dm-project. Choose Delete for Actions and confirm your choice.

Choose Instance profiles, and choose dm-instance-profile. Choose Delete and confirm your choice.

Choose Data providers, and then select the check boxes for dm-postgresql-source-provider and dm-postgresql-target-provider. Choose Delete and confirm your choice.

Delete your database users that you created in Step 2 and Step 3.

Drop the replication slot and the publisher in the source database by using the following code example.

SELECT pg_drop_replication_slot('migration_subscriber_{ARN}');
DROP PUBLICATION publication_{ARN};