Re: Logging queries cancelled due to replication timeouts

Christophe Pettus wrote:
> Greetings,
> 
> Is there a combination of options that will cause a hot standby replica to log queries that are cancelled due to a replication timeout (max_standby_streaming_delay)?

Sure, how about the system view pg_stat_database_conflicts in PG 9.1?

Our docs say:

	Add the pg_stat_database_conflicts</>
	system view to show queries that have been canceled and the
	reason (Magnus Hagander) 

       
	Cancellations can occur because of dropped tablespaces, lock
	timeouts, old snapshots, pinned buffers, and deadlocks.

I assume replication cancellations are also in there, no?

-- 
  Bruce Momjian          http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +