> On Wed, Dec 6, 2017 at 9:19 PM, Ian Barwick <ian.barw...@2ndquadrant.com> > wrote: >> Note this substitution sends a "pg_is_in_recovery()" query to the server >> each time it's encountered; unless there's something I'm overlooking I >> think that's the only reliable way to determine current recovery status. > > That seems kinda painful. > > And what happens in an aborted transaction?
Yeah. I think we need some from help backend for this. For example, a parameter status message can be used here. If PostgreSQL moves to the recovery state or vice versa, PostgreSQL sends the parameter status message to frontend. Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp