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
Re: Logging behavior not changing on reload Re: Logging behavior not changing on reload |
| Список | 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 по дате отправления: