What hook would you recommend that matches this criteria:
* Runs post-authentication
* ..Once
I was putting together a little extension module[0] intended to do
connection limits out-of-band with the catalog (so that hot standbys
and primaries can have different imposed connection limits), but am
stymied because I can't locate a hook matching this description.
My general approach has been to try to use
GetUserNameFromId(GetSessionUserId()), but this requires
InitializeSessionUserId be called first, and that has been causing me
some trouble.
ClientAuthentication_hook is too early (authentication has not yet
happened, InitializeSessionUserId has not been called). Many of the
other hooks are run per query (like the Executor hooks). And,
postinit.c is not giving me a lot of clues here and nothing with the
lexeme 'hook' is giving me a lot of confidence as seen in
typedefs.list/grep.
I appreciate any advice one can supply, thank you.
[0]: https://github.com/fdr/pg_connlimit