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

Started by zhong ming wuover 15 years ago1 messagesgeneral
Jump to latest
#1zhong ming wu
mr.z.m.wu@gmail.com

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?