On 04/09/2018 08:58, pavan95 wrote:
Hi Achilleas,
Either you created the subscription while the subscriber already had
existing data in the tables
I had taken a backup(along with data) and restored on both publisher and
subscriber. Later which I have created Publication and Subscription on both
the nodes.
As David said, this is wrong. In the subscriber side you start with plain schema and no data.
https://www.postgresql.org/docs/10/static/logical-replication-subscription.html "
The schema definitions are not replicated, and the published tables must exist on the subscriber
"
"
Each subscription will receive changes via one replication slot (see
Section 26.2.6). Additional temporary replication slots may be required for the initial data synchronization of pre-existing table data.
"
https://www.postgresql.org/docs/10/static/logical-replication-architecture.html "
Logical replication starts by copying a snapshot of the data on the publisher database.
"
This all implies that the tables on the subscriber must be empty before creating the subscription.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt