Re: logical Replication

From: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: logical Replication
Date: 2018-08-20 06:42:21
Message-ID: 1534747341264-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message pavan95 2018-08-20 06:47:06 Re: Logical Replication in Postgres 10.4
Previous Message Achilleas Mantzios 2018-08-20 06:33:50 Re: logical Replication