Postgres Pro
Downloads
Home   >   mailing lists

Re: Hot Standby - ERROR: canceling statement due to conflict with recovery - Mailing list pgsql-general

From Francois
Subject Re: Hot Standby - ERROR: canceling statement due to conflict with recovery
Date
Msg-id 1334263188394-5636744.post@n5.nabble.com
Whole thread Raw
In response to Hot Standby - ERROR: canceling statement due to conflict with recovery  (Sean Laurent <sean@studyblue.com>)
Responses Re: Re: Hot Standby - ERROR: canceling statement due to conflict with recovery  (raghu ram <raghuchennuru@gmail.com>)
List pgsql-general
Tree view 
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.

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Hot-Standby-ERROR-canceling-statement-due-to-conflict-with-recovery-tp3402417p5636744.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: regexp operator for array element compares needed
Next
From: Merlin Moncure
Date:
Subject: Re: Two entries with the same primary key