Re: Logging behavior not changing on reload - Mailing list pgsql-novice

From Matthew Foster - NOAA Federal
Subject Re: Logging behavior not changing on reload
Date
Msg-id CAP1ZYZEHp_wLJwBfS48ktpg3cxqbcbgmDW8wDiteYpRULXrkQQ@mail.gmail.com
Whole thread Raw
In response to Re: Logging behavior not changing on reload  (Jayadevan M <maymala.jayadevan@gmail.com>)
Responses Re: Logging behavior not changing on reload
Re: Logging behavior not changing on reload
Re: Logging behavior not changing on reload
List 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 by date:

Previous
From: Jayadevan M
Date:
Subject: Re: Logging behavior not changing on reload
Next
From: Jayadevan M
Date:
Subject: Re: Logging behavior not changing on reload