Repmgr and pg_dump conflict when backing up from standby

From: Ajlinux <ajlinux(at)protonmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Repmgr and pg_dump conflict when backing up from standby
Date: 2017-04-28 12:09:57
Message-ID: IcFCuhJtkfNgqretqAKNOxQNI_MLQ-VdeStWaShSgvGUL9HhDU6M9BPBdt-6b9LiOo2ymqpw0JCGPnCecYrSqvldx_0oG16EVzBKdYyfUy0=@protonmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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](https://protonmail.com), Swiss-based encrypted email.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Yaser Raja 2017-04-28 22:44:06 Re: Repmgr and pg_dump conflict when backing up from standby
Previous Message Albe Laurenz 2017-04-28 11:43:23 Re: wal segment size