Re: [ADMIN] Repmgr and pg_dump conflict when backing up from standby

Поиск
Список
Период
Сортировка
От Yaser Raja
Тема Re: [ADMIN] Repmgr and pg_dump conflict when backing up from standby
Дата
Msg-id CALkbEVnLJ+OE3-mOsags02F3RUVaLxUka9kcL_SnftbPS0bc=g@mail.gmail.com
обсуждение исходный текст
Ответ на [ADMIN] Repmgr and pg_dump conflict when backing up from standby  (Ajlinux <ajlinux@protonmail.com>)
Список pgsql-admin
Дерево обсуждения
Check out the configuration parameter "hot_standby_feedback"
Setting this parameter to 'on' will eliminate the query cancellation caused by the vacuum related conflicts.

Check out the documentation for more details:

Also check out the parameters max_standby_streaming_delay and max_standby_archive_delay.

Regards
Yaser



On Fri, Apr 28, 2017 at 8:09 AM, Ajlinux <ajlinux@protonmail.com> wrote:
Hi

I am doing replication using repmgr from master to standby.  I am trying to do my pg_dump of a database from the standby and the pg_dump always fails with:

Cancelling statement due to conflict with recovery.

Is there anything special you need to do to get pg_dump working on the standby.    Please advise the best way to do this.

I am running Postgres 9.4 on Ubuntu 14.04.

Sent from ProtonMail, Swiss-based encrypted email.



В списке pgsql-admin по дате отправления:

Предыдущее
От: Ajlinux
Дата:
Сообщение: [ADMIN] Repmgr and pg_dump conflict when backing up from standby
Следующее
От: Rahul Sharma
Дата:
Сообщение: [ADMIN] San replication corrupting postgres file...