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 201102272235.28567.jens@wilke.org
Whole thread Raw
In response to Re: Hot Standby - ERROR: canceling statement due to conflict with recovery  (Sean Laurent <sean@studyblue.com>)
List pgsql-general
On Sonntag, 27. Februar 2011, Sean Laurent wrote:

> In particular, I was really hoping to
> run database dumps against the standby, not the master.

One solution is to begin idle transactions on the master by using
e.g. dblink from the standby to the master before you start pg_dump
on the standby and end them after pg_dump (or whatever) is finished.

Jens

pgsql-general by date:

Previous
From: Julia Jacobson
Date:
Subject: Re: Linking against static libpq using Visual C++
Next
From: Julia Jacobson
Date:
Subject: Re: Linking against static libpq using Visual C++