Hi, I have the following configurations. On master: autovacuum=off vacuum_defer_cleanup_age=0
On slave: hot_standby_feedback = off max_standby_streaming_delay = 30s Now when I try to run a long query on slave and do some update or delete on the table on master I am getting the following error. ERROR: canceling statement due to conflict with recovery DETAIL: User query might have needed to see row versions that must be removed. The error code was : 40001 I am not running vacuum manually and autovacuum is 'off' What could possibly causing the conflict? -- View this message in context: http://postgresql.nabble.com/Update-or-Delete-causes-canceling-of-long-running-slave-queries-tp5903250.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
