Re: control pg_hba.conf via SQL

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: control pg_hba.conf via SQL
Дата
Msg-id 442C230D.8080706@dunslane.net
обсуждение исходный текст
Ответ на Re: control pg_hba.conf via SQL  (Chris Browne <cbbrowne@acm.org>)
Список 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 по дате отправления:

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: control pg_hba.conf via SQL
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Index vacuum improvements