Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux