On Wed, April 13, 2011 20:15, Henry C. wrote: > If I try and execute a long-lived SQL query on the slave, it eventually fails > with "canceling statement due to conflict with recovery". Replication is > definitely working (DML actions are propagated to the slave), but something > is amiss.
Let me ask the question another way. Following the hints at http://wiki.postgresql.org/wiki/Streaming_Replication: Between the primary and standby hosts, pg_current_xlog_location() and pg_last_xlog_receive_location()/select pg_last_xlog_replay_location() show what appears to be normal activity (ie, replication is happening successfully, and the numbers indicate health). primary% ps -ef | grep sender standby% ps -ef | grep receiver ...show things talking nicely and the numbers match. ps also shows a startup process recovering logs on the standby (which I assume is normal behaviour). However, a SELECT eventually fails with "canceling statement due to conflict with recovery". Where else can I check, or what else can I do to determine what the problem is? Thanks -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
