Re: replication timeout in pg_basebackup

From: "Aggarwal, Ajay" <aaggarwal(at)verizon(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: replication timeout in pg_basebackup
Date: 2014-03-11 12:50:07
Message-ID: 3B7431C850F4F347885C4CE5DD7B401993A93EA9@MIA20725MBX891A.apps.tmrk.corp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thats exactly what I was thinking after all other experiments. Couple of questions:
1) why did you say that 300 seconds is the upper limit? Is this enforced by Postgres? What if I want to set it to 10 minutes?
2) whats the downside of bigger replication timeout?

Thanks.

Ajay
________________________________
From: pgsql-general-owner(at)postgresql(dot)org [pgsql-general-owner(at)postgresql(dot)org] on behalf of John R Pierce [pierce(at)hogranch(dot)com]
Sent: Monday, March 10, 2014 9:58 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] replication timeout in pg_basebackup

On 3/9/2014 6:52 PM, Aggarwal, Ajay wrote:
Our replication timeout is default 60 seconds. If we increase the replication time to say 180 seconds, we see better results but backups still fail occasionally.

so increase it to 300 seconds, or whatever. thats an upper limit, it needs to be big enough that you DONT get into problems when doing stuff like basebackups.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2014-03-11 13:20:19 Re: Increase in max_connections
Previous Message matshyeq 2014-03-11 12:39:12 Re: libpq - lack of support to set the fetch size