Re: pgsql: Add hooks for session start and session end, take two - Mailing list pgsql-committers

From Alvaro Herrera
Subject Re: pgsql: Add hooks for session start and session end, take two
Date
Msg-id 20191002130839.GA7050@alvherre.pgsql
Whole thread Raw
In response to Re: pgsql: Add hooks for session start and session end, take two  (Michael Paquier <michael@paquier.xyz>)
Responses Re: pgsql: Add hooks for session start and session end, take two  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-committers
On 2019-Oct-02, Michael Paquier wrote:

> On Wed, Oct 02, 2019 at 01:27:50PM +0900, Fujii Masao wrote:
> > If only session end hook is problematic, you will commit session start
> > hook again?
> 
> Sure, it would be possible to cut the apple in half here.  Now my
> understanding was that both hooks were a set.  What do people think?

I think that having just session start is still useful, even if I
encourage you to get session end covered, because yes they do form a set
:-)  I don't think it's completely *impossible* to get session end to
work, only it needs to be run prior to any subsystem shutdown (I haven't
actually looked at the code, mind).  Of course, it'll need to be clear
that it might not run in certain cases.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-committers by date:

Previous
From: Michael Paquier
Date:
Subject: pgsql: Remove temporary WAL and history files at the end of archive rec
Next
From: Fujii Masao
Date:
Subject: Re: pgsql: Add hooks for session start and session end, take two