Re: logical Replication - Mailing list pgsql-admin

From pavan95
Subject Re: logical Replication
Date
Msg-id 1534747341264-0.post@n3.nabble.com
Whole thread Raw
In response to Re: logical Replication  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: logical Replication  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-admin
Hi Achilleas,

>> But still the data didn't got replicated. 
>> 
>> But I tried to drop and recreate the subscription and then the data got 
>> replicated within a fly. I really don't know what is the cause of this
>> lag? 

  >How do you monitor ? Do you check for ERROR in the logs?

I do monitor the ERRORS from the log file itself. 

But When I insert data in the publisher, And perform a check on the
subscriber, it is not getting replicated(most of the times) until I drop and
recreate my SUBSCRIPTION.

But later that, it is replicating very fast. Hope I specified the answer for
your question. 

Thanks in Advance

Regards,
Pavan
 



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html


pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: logical Replication
Next
From: pavan95
Date:
Subject: Re: Logical Replication in Postgres 10.4