To run migration jobs from an PostgreSQL source database, the database may require some configuration changes. If Relational Migrator determines the database needs configuration changes, it automatically generates a SQL script with the required changes. It is recommended to have a Database Administrator (DBA) review the commands in this script and execute them. This page provides more details on the required configuration steps.
Before you Begin
If PostgreSQL is configured as a cluster, Relational Migrator must connect to the master server.
Steps
For snapshot jobs against PostgreSQL, the service account requires
schema USAGE and table SELECT permissions.
GRANT USAGE ON SCHEMA <schema_name> TO <database_user_name>; GRANT SELECT ON TABLE <schema_name>.<table_name> TO <database_user_name>;
Learn More
Relational Migrator relies on the open-source Debezium connector to capture row-level changes. For more details, see Debezium PostgreSQL.