Re: what about _PG_fini - Mailing list pgsql-hackers

From Tom Lane
Subject Re: what about _PG_fini
Date
Msg-id 14137.1261603607@sss.pgh.pa.us
Whole thread Raw
In response to what about _PG_fini  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Responses Re: what about _PG_fini
List pgsql-hackers
Cédric Villemain <cedric.villemain.debian@gmail.com> writes:
> I wonder what is the future of "_PG_fini", documentation say at [1]:
> "Note that _PG_fini will only be called during an unload of the file,
> not during process termination. (Presently, unloads are disabled and
> will never occur, but this may change in the future.)"

What we'd need to work out before (re)enabling _PG_fini is some
consistent rules for allowing multiple modules to get into *and out of*
the same hook pointers.  The current coding methods are very
load-order-dependent, and that would have to be fixed somehow.

> 1. do we want a _PG_fini which is call on server stop ?
> 2. what's actually the best way to execute some code when server stop,
> if one have ideas ... ?

In any case, _PG_fini would have approximately nothing to do with "code
to be executed on server stop".  It would happen at session end,
typically.

Personally I'd suggest putting whatever you have in mind into your
service start/stop scripts.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Removing pg_migrator limitations
Next
From: Tom Lane
Date:
Subject: Re: Removing pg_migrator limitations