Postgres Pro
Downloads
Home   >   mailing lists

[ADMIN] Repmgr and pg_dump conflict when backing up from standby - Mailing list pgsql-admin

From Ajlinux
Subject [ADMIN] Repmgr and pg_dump conflict when backing up from standby
Date
Msg-id IcFCuhJtkfNgqretqAKNOxQNI_MLQ-VdeStWaShSgvGUL9HhDU6M9BPBdt-6b9LiOo2ymqpw0JCGPnCecYrSqvldx_0oG16EVzBKdYyfUy0=@protonmail.com
Whole thread Raw
Responses Re: [ADMIN] Repmgr and pg_dump conflict when backing up from standby  (Yaser Raja <yrraja@gmail.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: [ADMIN] wal segment size
Next
From: Yaser Raja
Date:
Subject: Re: [ADMIN] Repmgr and pg_dump conflict when backing up from standby