|
On 04/09/2018 08:58, pavan95 wrote:
As David said, this is wrong. In the subscriber side you start with plain schema and no data.Hi Achilleas,Either you created the subscription while the subscriber already hadexisting 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. 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 |
