Re: Logging behavior not changing on reload

Поиск
Список
Период
Сортировка
От Matthew Foster - NOAA Federal
Тема Re: Logging behavior not changing on reload
Дата
Msg-id CAP1ZYZEHp_wLJwBfS48ktpg3cxqbcbgmDW8wDiteYpRULXrkQQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Logging behavior not changing on reload  (Jayadevan M <maymala.jayadevan@gmail.com>)
Ответы Re: Logging behavior not changing on reload  (Jayadevan M <maymala.jayadevan@gmail.com>)
Re: Logging behavior not changing on reload  (Tovo Rabemanantsoa <tovo.rabemanantsoa@bordeaux.inra.fr>)
Re: Logging behavior not changing on reload  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Thank you for the quick reply.  SHOW indeed indicates that the parameters have not actually changed.  I guess my next question is: Why did they not change on reload?

Matt



On Wed, Apr 2, 2014 at 8:29 AM, Jayadevan M <maymala.jayadevan@gmail.com> wrote:
You could try show command (http://www.postgresql.org/docs/9.3/static/sql-show.html) and see if the changes have taken effect. Usually there are comments against each parameter which mention  if a restart is required. Example,
port = 5432                # (change requires restart)


On Wed, Apr 2, 2014 at 6:36 PM, Matthew Foster - NOAA Federal <matthew.foster@noaa.gov> wrote:
I changed a few logging parameters on our 9.1 server (e.g. log_rotation_age, log_rotation_size, log_min_messages).  After a reload, the logging behavior has not changed.  Is a restart required for these?  The documentation doesn't indicate that it is.

Thanks.

Matt



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

Предыдущее
От: Jayadevan M
Дата:
Сообщение: Re: Logging behavior not changing on reload
Следующее
От: Jayadevan M
Дата:
Сообщение: Re: Logging behavior not changing on reload