Re: control pg_hba.conf via SQL

[Andrew Dunstan <andrew(at)dunslane(dot)net>]

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