Re: terminating walsender process due to replication timeout

2019-05-30 Thread AYahorau
reality? Best regards, Andrei From: Kyotaro HORIGUCHI To: ayaho...@ibagroup.eu, Cc: pgsql-gene...@postgresql.org, rene.romer...@gmail.com Date: 24/05/2019 09:42 Subject:Re: terminating walsender process due to replication timeout Hello. At Fri, 17 May 2019 11:04:58 +0300

Re: terminating walsender process due to replication timeout

2019-05-23 Thread Kyotaro HORIGUCHI
Hello. At Fri, 17 May 2019 11:04:58 +0300, ayaho...@ibagroup.eu wrote in > Can frequent database operations cause getting a standby server behind? Is > there a way to avoid this situation? > I checked that walsender works well in my test if I set > wal_sender_timeout at least to 5 second. It

Re: terminating walsender process due to replication timeout

2019-05-23 Thread Achilleas Mantzios
ck on wood. Regards, Andrei From: Andrei Yahorau/IBA To: Kyotaro HORIGUCHI , Cc: pgsql-gene...@postgresql.org, rene.romer...@gmail.com Date: 17/05/2019 11:04 Subject: Re: terminating walsender process due to replicati

Re: terminating walsender process due to replication timeout

2019-05-23 Thread AYahorau
gresql.org, rene.romer...@gmail.com Date: 17/05/2019 11:04 Subject: Re: terminating walsender process due to replication timeout Hello. Thanks for the answer. Can frequent database operations cause getting a standby server behind? Is there a way to avoid this situation? I checked that walse

Re: terminating walsender process due to replication timeout

2019-05-17 Thread AYahorau
HORIGUCHI To: ayaho...@ibagroup.eu, Cc: rene.romer...@gmail.com, pgsql-gene...@postgresql.org Date: 16/05/2019 10:36 Subject:Re: terminating walsender process due to replication timeout Hello. At Wed, 15 May 2019 10:04:12 +0300, ayaho...@ibagroup.eu wrote in > Hello, >

Re: terminating walsender process due to replication timeout

2019-05-16 Thread Kyotaro HORIGUCHI
Hello. At Wed, 15 May 2019 10:04:12 +0300, ayaho...@ibagroup.eu wrote in > Hello, > Thank You for the response. > > Yes that's possible to monitor replication delay. But my questions were > not about monitoring network issues. > > I use exactly wal_sender_timeout=1s because it allows to dete

Re: terminating walsender process due to replication timeout

2019-05-15 Thread AYahorau
? If it is so, why I do I face this problem again? Thank you in advance. Best regards, Andrei From: Rene Romero Benavides To: ayaho...@ibagroup.eu, Cc: Postgres General Date: 14/05/2019 20:12 Subject: Re: terminating walsender process due to replication timeout To d

Re: terminating walsender process due to replication timeout

2019-05-14 Thread Rene Romero Benavides
To detect network issues maybe you could monitor replication delay. On Mon, May 13, 2019 at 6:42 AM wrote: > Hello PostgreSQL Community! > > I faced an issue on my linux machine using Postgres 11.3 . > I have 2 nodes in db cluster: master and standby. > I tried to perform a plenty of long-runnin