On 20/08/2018 09:42, pavan95 wrote:
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.
OS? (Linux, BSD, etc)
PostgreSQL Version?
Also give the current settings of wal_receiver_timeout , wal_sender_timeout , increasing those to '5 min' solved my issues.
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
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
