We are using the pglogical extension for replicating a PostgreSQL database into Google Cloud, using the Database Migration Service. We are able to reach the continuous replication phase successfully. The problem is after this.
Over the source database is running a system that executes some checks in the database, specifically in the "public" schema. This check is detecting changes in this schema and is removing all the changes, and for this reason, the replication is failing. Could you give me information about what modifications performs pglogical/Database Migration Service in the "public" schema?
Thanks in advance.