pg_dump: Dumping the contents of table "invoices" failed: PQgetResult() failed. pg_dump: Error message from server: ERROR: canceling statement due to conflict with recovery DETAIL: User was holding a relation lock for too long. pg_dump: The command was: COPY dm.invoices (invoice_id, format_version, ts_issue, ts_ack, customer_id, code, tag, account_data, customer_data, invoice_data, invoice_items_data) TO stdout;
If I run the pg_dump from the MASTER DB, it runs ok. But as the DB is 2 TB, I just can't let it coping from Production. It has to be from a slave server (I've also tried to copy from another slave. I get the same error).
What am I doing wrong? How can I solve the problem?