Questions about Logical Replication - Issue ???

From: FOUTE K(dot) Jaurès <jauresfoute(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Questions about Logical Replication - Issue ???
Date: 2020-07-30 13:54:08
Message-ID: CAHQ1jfcP265j60UStMbzm-Z+MHTugtmne2QytUhaqRCz9iY=ng@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi everyone,

Situation:

- A Master Database on the HQ
- i make a dump of the master database to the Subdivision Server
- I create à Publication like: CREATE PUBLICATION
iNOV_MasterData_Table_Pub FOR TABLE M_Product; On the Master Database
- On the Subdivision Server, I create a Subscription like: CREATE
SUBSCRIPTION iNOV_MasterData_Table_XXX_Sub CONNECTION '........'
PUBLICATION iNOV_MasterData_Table_Pub;
- On the log, I have this error:
- 2020-07-30 14:32:59.366 WAT [8022] ERROR: duplicate key value
violates unique constraint "m_product_pkey"
2020-07-30 14:32:59.366 WAT [8022] DETAIL: Key
(m_product_id)=(1001426) already exists.
2020-07-30 14:32:59.366 WAT [8022] CONTEXT: COPY m_product, line 1
2020-07-30 14:32:59.369 WAT [1536] LOG: background worker "logical
replication worker" (PID 8022) exited with exit code 1

What can I do to solve this? Is it normal ? It
BTW: When I create Subscription With the option (copy_data = false), I am
able to replicate the new record.

--
Jaurès FOUTE

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Diego 2020-07-30 14:03:24 Re: Track pgsql steps
Previous Message Olivier Leprêtre 2020-07-30 13:11:09 RE: Track pgsql steps