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

From: zhong ming wu <mr(dot)z(dot)m(dot)wu(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump: Error message from server: ERROR: canceling statement due to conflict with recovery
Date: 2010-12-02 20:17:32
Message-ID: AANLkTi=qGCDRUWAx7r83ADjuJqJpGGvsJyY7qT-R8_Xo@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-12-02 20:23:34 Re: PG84 and SELinux
Previous Message Radosław Smogura 2010-12-02 19:37:17 Re: Full Text Partial Match at begining