CODEWITHSUNDEEP
postgresqlschemadatabase-replicationsymmetricds
Maly Mohsem Ahmed
Maly Mohsem Ahmed

Reputation: 41

SymmetricDS replication configuration for different schemas PostgreSQL

I want to replicate other schemas rather than the public schema. I have configured the sym_trigger table for the different schema but it doesn't work cause there were no sym_* tables in that particular schema. Is there any way to configure the xxxx.properties file or just use this command

alter user {user name} set search_path to {schema name};

and configure the sym_* tables just like public schemas?

Upvotes: 0

Views: 250

Answers (1)

Evan
Evan

Reputation: 362

The SymmetricDS tables will reside in the schema that is the default schema when you log in. If you want to access non-SymmetricDS tables in different schemas, you need to specify the source_schema_name in sym_trigger.

Upvotes: 2

Related Questions