On 3/10/20 5:16 AM, PegoraroF10 wrote:
Now I have the same problem with a different message. I´ve added a table on all schemas and did a refresh publication. when postgres sees a new table on publisher he goes to replicamand trucates that table to start copying. ok but I have 300 schemas, how can I know what schema that table belongs to ?
Postgres version(s)? Are you using the built in logical replication or the pglogical plugin?
On log of replica server ... Message cannot truncate a table referenced in a foreign key constraint Detail Table "rel_indicacao" references "cad_digitacao". Hint Truncate table "rel_indicacao" at the same time, or use TRUNCATE ... CASCADE. -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
