Re: Improving pg_hba.conf

What I mean is, do host lookups first in the text file, then if a
pg_hostaccess table (example) exists, check it for host entries. This
alleviates HUP or restart etc. to reload a config file.

David

Bruce Momjian wrote:

>>>
>>>I haven't heard of any more issues with pg_hba.conf so I will mark the
>>>item as done. I did cleanup the comments in the file. I have also
>>>added a TODO item:
>>>
>>> * Read pg_hba.conf only on postmaster startup or SIGHUP
>>>
>>If you do this, can you add an access table for secondary lookups? I
>>tend to update host access frequently and personally I think it'd be
>>dandy to have a table that can be updated for access as well as the
>>primary pg_hba.conf file.
>>
>
>Sorry, I don't understand what secondary lookups are.
>