Re: control pg_hba.conf via SQL - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: control pg_hba.conf via SQL
Date
Msg-id 442C230D.8080706@dunslane.net
Whole thread Raw
In response to Re: control pg_hba.conf via SQL  (Chris Browne <cbbrowne@acm.org>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Chris Browne
Date:
Subject: Re: control pg_hba.conf via SQL
Next
From: Heikki Linnakangas
Date:
Subject: Re: Index vacuum improvements