Re: control pg_hba.conf via SQL

Chris Browne wrote:
>> Maybe we could do something like this: if there is a pg_hba.conf
>> file present, then use it as now and ignore the access rights table
>> - if someone does GRANT/REVOKE CONNECT while under pg_hba.conf then
>> process it but issue a warning. Maybe there could also be an initdb
>> switch that gave users a choice.
>>     
>
> initdb is a terrible choice for that; that means you have to
> re-initialize the database to change the option.
>
>   

Not at all. Where did you get that idea? Not everything set by initdb is 
set in concrete. For example, initdb sets shared_buffers but you sure 
don't need to rerun initdb to change that or anything else it sets in 
postgresql.conf.

cheers

andrew