Re: Permanent settings

Поиск
Список
Период
Сортировка
От Roberts, Jon
Тема Re: Permanent settings
Дата
Msg-id 1A6E6D554222284AB25ABE3229A927627155DC@nrtexcus702.int.asurion.com
обсуждение исходный текст
Ответ на Re: Permanent settings  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
>
> Gregory Stark wrote:
>
> > The alternative is to have two files and read them both. Then if you
> change a
> > variable which is overridden by the other source you can warn that
the
> change
> > is ineffective.
> >
> > I think on balance the include file method is so much simpler that I
> prefer it.
>
> I think this is a good idea.  I would suggest being able to query
> exactly which config file a setting came from -- so you can see
whether
> it's the stock postgresql.conf, or the locally-modified
> postgresql.local.conf.
>

So a junior DBA goes to manage the db.  Makes a change the
postgresql.conf file and bounces the db.  The change doesn't stick.
That doesn't sound like fun and it also sounds like Oracle's spfile and
pfile.



Jon


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

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Including PL/PgSQL by default
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Including PL/PgSQL by default