PostgreSQL - Cancelling statement due to conflict with recovery

Running queries on a standby replica node may cause queries to error out with a message 'Cancelling statement due to conflict with recovery'.