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