Re: [GENERAL] Hot standby usage issue

2010-10-07 Thread Rajesh Kumar Mallah
Hi , The 'problem' was remedied to certain extent by increasing max_standby_streaming_delay=30 # 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 wrote: > Dear List , > > We have

Re: [GENERAL] Hot standby usage issue

2010-10-06 Thread Rajesh Kumar Mallah
both servers are on same gigabit switch. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Hot standby usage issue

2010-10-06 Thread Rajesh Kumar Mallah
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 th