pg_dump: Error message from server: ERROR: canceling statement due to conflict with recovery

Поиск
Список
Период
Сортировка
От zhong ming wu
Тема pg_dump: Error message from server: ERROR: canceling statement due to conflict with recovery
Дата
Msg-id AANLkTi=qGCDRUWAx7r83ADjuJqJpGGvsJyY7qT-R8_Xo@mail.gmail.com
обсуждение исходный текст
Список pgsql-general

pg_dump: SQL command 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 public.i...... TO stdout;
pg_dumpall: pg_dump failed on database "aaaa", exiting

–-------

I tried to do pg_dumpall on a read-only hotstandby.  This error??

Time taken to dump longer than archive_timeout is the problem?

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

Предыдущее
От: Radosław Smogura
Дата:
Сообщение: Re: Full Text Partial Match at begining
Следующее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: PG84 and SELinux