Re: Repmgr and pg_dump conflict when backing up from standby

[Yaser Raja <yrraja@xxxxxxxxx>]

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:

    https://www.postgresql.org/docs/9.4/static/runtime-config-replication.html

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@xxxxxxxxxxxxxx> 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.