Migrate your AWS RDS/Aurora PostgreSQL database to an HM-managed database v1.3.2

These are all the steps you need to perform a migration from an AWS RDS for PostgreSQL or Aurora PostgreSQL database to a database managed by Hybrid Manager (HM).

Prepare your source database

Preparing your source database for data migration involves creating a dedicated user for the migration and altering the database configuration to enable the replication features.

1. Preparing the source AWS RDS/Aurora PostgreSQL database.

Assess the database (optional)

Install and configure the HM agent with your database to obtain observability and monitoring data for your Postgres database. This optional step also provides high-level migration metrics, like schema count and names, table count, and object count.

1. Configure the HM agent to assess your database.

Create a destination database

Create a cluster in the HM instance to host the destination database.

1. Create a destination database in HM.

Migrate your schema

Handle incompatibilities and transfer your schemas.

1. Handle constraints for schema migration.

2. Migrate schemas.

Migrate your data

Execute the data transfer and complete the final cleanup steps.

1. Create project credentials for the data migration.

2. Configure the DMS agent in reader mode for a data migration.

3. Verify your source database appears in the HM console.

4. Create and performing the data migration.

5. Finalize the migration (for streaming migrations only).

6. Apply excluded constraints.