0

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 public;

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;

to

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?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.