Standby pg_dump Conflict with Recovery

Поиск
Список
Период
Сортировка
От Louis Battuello
Тема Standby pg_dump Conflict with Recovery
Дата
Msg-id B5C12DD4-ECF4-446C-A37D-7CF702240696@etasseo.com
обсуждение исходный текст
Ответы Re: Standby pg_dump Conflict with Recovery
Список pgsql-general
Дерево обсуждения
Hell All,

I’ve got a confusing issue with dumping data from a standby PostgreSQL 9.4.5 database.

At night, on a nearly completely idle server, I run a pg_dump of a database that contains numerous small tables and one 3GB table. The dump consistently fails when reaching the 3GB table with this message:

pg_dump: Dumping the contents of table “<table>" failed: PQgetResult() failed.
pg_dump: Error message from server: ERROR:  canceling statement due to conflict with recovery
DETAIL:  User query might have needed to see row versions that must be removed.
pg_dump: The command was: COPY <table> (...) TO stdout;

I have replication slots enabled on the primary (“repmgr_slot_3" for the standby pg_dump source), and I’m using hot_standby_feedback. After getting the failure a couple times, I temporarily set max_standby_archive_delay and max_standby_streaming_delay to -1 to allow infinite delay on the standby,  just to see if I could get the dump to complete. I still encountered the above error.


postgres=# select * from pg_replication_slots ;
   slot_name   | plugin | slot_type | datoid | database | active |  xmin   | catalog_xmin | restart_lsn 
---------------+--------+-----------+--------+----------+--------+---------+--------------+-------------
 repmgr_slot_2 |        | physical  |        |          | t      |         |              | A/C6502880
 repmgr_slot_3 |        | physical  |        |          | t      | 1356283 |              | A/C6502880
(2 rows)

Is there some other configuration setting I’m forgetting?

Thanks,
Louis

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