Re: Hot Standby - ERROR: canceling statement due to conflict with recovery

From: Jens Wilke <jens(at)wilke(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Hot Standby - ERROR: canceling statement due to conflict with recovery
Date: 2011-02-27 21:35:28
Message-ID: 201102272235.28567.jens@wilke.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Julia Jacobson 2011-02-27 22:17:17 Re: Linking against static libpq using Visual C++
Previous Message Julia Jacobson 2011-02-27 21:10:00 Re: Linking against static libpq using Visual C++