I'm setting up DMS to perform replication from a non-RDS database.
After running the suggested code to create wrapper functions, I'm finding our migrations are breaking with errors that indicate problems with the schema search path (eg it was trying to find our SequelizeMigrations table in
pg_catalog instead of
Our application isn't specifying schema and assuming everything lives in public, so I've changed the user path from
ALTER USER <user name> SET search_path = fnRenames, pg_catalog, "$user", public;
ALTER USER <user name> SET search_path = "$user", public, fnRenames, pg_catalog;
This seems to work fine, but I'm treading out of my depth, so am asking if there are any issues I could run into with these changes?