Re: [GENERAL] FATAL: terminating connection due to conflict with recovery

2011-08-31 Thread Jeff Ross
On 08/30/11 18:03, Fujii Masao wrote: On Wed, Aug 31, 2011 at 5:51 AM, Jeff Ross wrote: Is there a setting in this or something else that I should tweak so this query can complete against the replica? Google turned up some threads on the error code associated with the error but I didn't find m

Re: [GENERAL] FATAL: terminating connection due to conflict with recovery

2011-08-30 Thread Craig Ringer
On 31/08/2011 4:51 AM, Jeff Ross wrote: On my workstation using psql this query runs in about 1.5 minutes. I can choose the quarter the query uses and I'm virtually positive that no rows in that set will be updated or deleted so the error message to me seems wrong. AFAIK: There may be other da

Re: [GENERAL] FATAL: terminating connection due to conflict with recovery

2011-08-30 Thread Fujii Masao
On Wed, Aug 31, 2011 at 5:51 AM, Jeff Ross wrote: > Is there a setting in this or something else that I should tweak so this > query can complete against the replica?  Google turned up some threads on > the error code associated with the error but I didn't find much else that > seems applicable.