Re: proposal : backend startup hook / after logon trigger
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Tomas Vondra" <tv@fuzzy.cz>
Cc: "Robert Haas" <robertmhaas@gmail.com>, pgsql-hackers@postgresql.org
Date: 2011-11-25T16:48:09Z
Lists: pgsql-hackers
"Tomas Vondra" <tv@fuzzy.cz> writes: > On 25 Listopad 2011, 2:44, Robert Haas wrote: >> I've thought of this before, but I'm not exactly clear on what the use >> cases are. > The startup hook is useful for initializing an extension written in C, > when the extension was loaded from postgresql.conf. If you need to perform > the initialization for each db separately (so that you can decide whether > to apply the extension to the user/database), you need to do that after > the backend starts. If you need that, just load the extension with local_preload_libraries. regards, tom lane