Re: Providing catalog view to pg_hba.conf file - Patch submission

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Providing catalog view to pg_hba.conf file - Patch submission
Дата
Msg-id CAM-w4HOFSCLk_erqxLOjbu9dv3vGcuC5RuCOi5C0y-GKL+j8_w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Providing catalog view to pg_hba.conf file - Patch submission  (Haribabu Kommi <kommi.haribabu@gmail.com>)
Ответы Re: Providing catalog view to pg_hba.conf file - Patch submission  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers

On Mon, Mar 2, 2015 at 6:36 AM, Haribabu Kommi <kommi.haribabu@gmail.com> wrote:
Loading pg_hba.conf during SIGHUP in the backends will solve the
problem of displaying the
data which is not yet loaded. This change may produce a warning if it
fails to load pg_hba.conf in the backends.

This seems like the right strategy to me. It parallels pg_settings and postgresql.conf which means one less surprising quirk for future developers.

An idle thought, in the long-term it seems like it would be better to have postmaster have some shared memory where it dumps out a config data structure that backends can all see. That might help with the race-conditions we have now when reloading config data where different backends could end up with different interpretations of the same config or even see different configs if the files are being modified concurrently. But I think that would have to be done very carefully so the postmaster doesn't sacrifice any reliability.





--
greg

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Shigeru Hanada
Дата:
Сообщение: Re: Join push-down support for foreign tables
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Redesigning checkpoint_segments