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

Поиск
Список
Период
Сортировка
От Jens Wilke
Тема Re: Hot Standby - ERROR: canceling statement due to conflict with recovery
Дата
Msg-id 201102272235.28567.jens@wilke.org
обсуждение исходный текст
Ответ на Re: Hot Standby - ERROR: canceling statement due to conflict with recovery  (Sean Laurent <sean@studyblue.com>)
Список 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 по дате отправления: