Re: Hot Standby - ERROR: canceling statement due to conflict with recovery - Mailing list pgsql-general

From Jens Wilke
Subject Re: Hot Standby - ERROR: canceling statement due to conflict with recovery
Date
Msg-id 201102272005.00234.jens@wilke.org
Whole thread Raw
In response to Hot Standby - ERROR: canceling statement due to conflict with recovery  (Sean Laurent <sean@studyblue.com>)
Responses Re: Hot Standby - ERROR: canceling statement due to conflict with recovery
List pgsql-general
On Sonntag, 27. Februar 2011, Sean Laurent wrote:

> Unfortunately, most queries against the hot standby fail. Worse
> yet, pg_dump fails:
...
> I'm not entirely certain I understand why I'm seeing this. Nor do
> I understand how to fix or work around this. Any advice or
> suggestions would be greatly appreciated.

Long running queries on the standby are a bit tricky, because they
might need to see row versions that are already removed on the
master.
It's well documented:
http://www.postgresql.org/docs/9.0/static/hot-standby.html

HTH, Jens



pgsql-general by date:

Previous
From: Sean Laurent
Date:
Subject: Hot Standby - ERROR: canceling statement due to conflict with recovery
Next
From: Adrian Klaver
Date:
Subject: Re: database is bigger after dump/restore - why? (60 GB to 109 GB)