On Fri, Apr 13, 2012 at 2:09 AM, Francois
<lacouf@gmail.com> wrote:
One solution, for backups anyway, is to pause the replication on the slave
machines with the command: pg_xlog_replay_pause() and
pg_xlog_replay_resume(). We still don't have a solution for long running
queries, mayber have a mechanism to retry them when they fail with that
specific error.
For resolving this issue,Set below parameters values equal to total execution time of long running statements in Postgresql.conf of Standby server.
max_standby_archive_delay
max_standby_streaming_delay
and then RELOAD the PostgreSQL cluster.
--
Thanks & Regards,
Raghu Ram
EnterpriseDB: http://www.enterprisedb.com