Re: Dynamic configuration via LDAP in postmaster

Thank you for the advice, nowadays we(company where I work) use such scheme
but that scheme is not always useful at the stage of development of the
back-end infrastructure. Also we have found a better solution : have ldap
for dynamic configuraion out of the box.

So question is following: if you got such task, where do you put ldap
functionality inside postgres daemon?

PS I have read the basics of ideology Posgresql and I know why you guys
make main server tiny in functionality and this is great, but we would like
to have more complex solution.
This feature may be useful not only for me and my company.

On 3 December 2013 20:54, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>wrote:

> On 12/03/2013 05:44 PM, Vasily Soshnikov wrote:
>
>> I need advise about where is best place for adding such features.
>>
>> Currently I found that 'postmaster' have event loop(including handling
>> SIGHUP) inside PostgressMain(postgress.c) for realoding configuration
>> file, based on my investigation my plan is handling ldap events just
>> before
>> SIGHUP.
>>
>> PS I guess tomorrow I will start implement this feature inside
>> 'postmaster', but before I start I wish to know expert opinion about where
>> are most good place for dispatching of incomming messages(about
>> configuration has changed etc) from the ldap.
>>
>
> postmaster is kept very small on purpose, because if that process dies, it
> will take the whole server down with it. I'd suggest writing a custom
> background worker that talks with the ldap server. It can then write the
> changes to the configuration files, and send SIGHUP to reload.
>
> - Heikki
>

--

*Regard,Soshnikov Vasily mailto:dedok(dot)mad(at)gmail(dot)com <dedok(dot)mad(at)gmail(dot)com>*