Re: [GENERAL] Postgres 9.6.2 and pg_log - solved

2017-04-28 Thread Mark Watson
De : pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] De la part de Mark Watson Envoyé : Monday, April 24, 2017 3:39 PM À : David G. Johnston Cc : (pgsql-general@postgresql.org) Objet : Re: [GENERAL] Postgres 9.6.2 and pg_log De : David G. Johnston

Re: [GENERAL] Postgres 9.6.2 and pg_log

2017-04-24 Thread Mark Watson
De : David G. Johnston [mailto:david.g.johns...@gmail.com] Envoyé : Monday, April 24, 2017 3:15 PM À : Mark Watson Cc : (pgsql-general@postgresql.org) Objet : Re: [GENERAL] Postgres 9.6.2 and pg_log On Mon, Apr 24, 2017 at 11:27 AM, Mark Watson mailto:mark.wat...@jurisconcept.ca>>

Re: [GENERAL] Postgres 9.6.2 and pg_log

2017-04-24 Thread David G. Johnston
On Mon, Apr 24, 2017 at 11:27 AM, Mark Watson wrote: > > log_destination = 'stderr' # Valid values are > combinations of > > > # stderr, csvlog, syslog, and eventlog, > > > # depending on platform. csvlog > > > # requires logging_collector to be on. > > > > # This is

Re: [GENERAL] Postgres 9.6.2 and pg_log

2017-04-24 Thread Mark Watson
De : David G. Johnston [mailto:david.g.johns...@gmail.com] Envoyé : Monday, April 24, 2017 2:18 PM À : Mark Watson Cc : (pgsql-general@postgresql.org) Objet : Re: [GENERAL] Postgres 9.6.2 and pg_log On Mon, Apr 24, 2017 at 10:58 AM, Mark Watson mailto:mark.wat...@jurisconcept.ca>> wrote

Re: [GENERAL] Postgres 9.6.2 and pg_log

2017-04-24 Thread David G. Johnston
On Mon, Apr 24, 2017 at 10:58 AM, Mark Watson wrote: > > The lines log_rotation_age and log_rotation_size are commented, and > currently are: > > #log_rotation_age = 1d # Automatic > rotation of logfiles will > > > # happen after that time. 0 disables. > > #log_ro

Re: [GENERAL] Postgres 9.6.2 and pg_log

2017-04-24 Thread Mark Watson
De : David G. Johnston [mailto:david.g.johns...@gmail.com] Envoyé : Monday, April 24, 2017 1:34 PM À : Mark Watson Cc : (pgsql-general@postgresql.org) Objet : Re: [GENERAL] Postgres 9.6.2 and pg_log On Mon, Apr 24, 2017 at 8:43 AM, Mark Watson mailto:mark.wat...@jurisconcept.ca>> wrote

Re: [GENERAL] Postgres 9.6.2 and pg_log

2017-04-24 Thread Mark Watson
De : David G. Johnston [mailto:david.g.johns...@gmail.com] Envoyé : Monday, April 24, 2017 1:34 PM À : Mark Watson Cc : (pgsql-general@postgresql.org) Objet : Re: [GENERAL] Postgres 9.6.2 and pg_log On Mon, Apr 24, 2017 at 8:43 AM, Mark Watson mailto:mark.wat...@jurisconcept.ca>> wrote

Re: [GENERAL] Postgres 9.6.2 and pg_log

2017-04-24 Thread David G. Johnston
On Mon, Apr 24, 2017 at 8:43 AM, Mark Watson wrote: > Good day all, > > > > I just noticed an anomaly regarding the logging. I have my logging set up > as follows: > > log_filename = 'postgresql-%d.log' > > log_truncate_on_rotation = on > ​I don't see "log_rotation_age" and/or "log_rotation_size

[GENERAL] Postgres 9.6.2 and pg_log

2017-04-24 Thread Mark Watson
Good day all, I just noticed an anomaly regarding the logging. I have my logging set up as follows: log_filename = 'postgresql-%d.log' log_truncate_on_rotation = on My log file postgresql-21.log contains only entries for today (April 24). When I restart the service, entries correctly start accu