From: | pavan95 <pavan(dot)postgresdba(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4 |
Date: | 2018-09-03 07:50:28 |
Message-ID: | 1535961028810-0.post@n3.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Achilleas,
But the logical Replication is working fine. I mean to say that the data is
replicating between Publisher and Subscriber. I have problem only with my
logs. Most common errors found on my Subscriber are:
1. duplicate key value violates unique constraint
2. worker process: logical replication worker for subscription 6992680 sync
694478 (PID 13459) exited with exit code 1
3. logical replication table synchronization worker for subscription
""subscription_name"", table ""tbl_A"" has started
>>Either you created the subscription while the subscriber already had
existing data in the tables, or you are inserting/updating dataI or Ds/keys
on the subscriber that cause the problem .
Even if I did that it will face this error the very first time it is trying
to establish sync between publisher and subscriber but not every
time(correct me if I am wrong)
The 2'nd & 3'rd are not actually ERRORS. They are LOG messages. Please
suggest me if I went wrong somewhere.
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleas Mantzios | 2018-09-03 08:04:04 | Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4 |
Previous Message | Andreas Kretschmer | 2018-09-03 07:35:16 | Re: trying to delete most of the table by range of date col |