Hi ,
The 'problem' was remedied to certain extent by increasing
max_standby_streaming_delay=300000 # values in milliseconds
I set it to 5 mins which is acceptable to our application.
regds
Rajesh Kumar Mallah.
On Thu, Oct 7, 2010 at 9:55 AM, Rajesh Kumar Mallah
<mallah.rajesh@gmail.com> wrote:
> Dear List ,
>
> We have setup primary/slave in HS & SR mode. We are diverting a part of
> read only queries to the slave.
>
> The problem is that we are intermittently getting errors
> ERROR: canceling statement due to conflict with recovery
> on slave. We know that the tables which are participating in these queries
> are not frequently updated ones. Can anyone suggest how can we
> debug the situation.
>
> Regds
> Rajesh Kumar Mallah.
>