Обсуждение: 8.3.x log maintenance
Hi, I have postgres logging into data/pg_log/ which works great. My question is there and option that tells postgres to only keep the last "n" log files? Or does someone have a script that be run daily to remove the older log files so that I only end up with "n" log files? Thanks, Steve 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 used when logging to stderr: logging_collector = on # Enable capturing of stderr and csvlog # into log files. Required to be on for # csvlogs. # (change requires restart) # These are only used if logging_collector is on: log_directory = 'pg_log' # directory where log files are written, # can be absolute or relative to PGDATA log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern, # can include strftime() escapes log_truncate_on_rotation = off # If on, an existing log file of the # same name as the new log file will be # truncated rather than appended to. # But such truncation only occurs on # time-driven rotation, not on restarts # or size-driven rotation. Default is # off, meaning append to existing files # in all cases. log_rotation_age = 1d # Automatic rotation of logfiles will # happen after that time. 0 to disable. log_rotation_size = 10MB # Automatic rotation of logfiles will # happen after that much log output. # 0 to disable.
On 27/10/2008 13:19, Steve Clark wrote: > I have postgres logging into data/pg_log/ which works great. My > question is there and option that tells postgres to only keep the > last "n" log files? Or does someone have a script that be run daily > to remove the older log files so that I only end up with "n" log > files? logrotate? Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
Steve Clark <sclark@netwolves.com> writes: > I have postgres logging into data/pg_log/ which works great. My question is there > and option that tells postgres to only keep the last "n" log files? The usual solution is to choose a filename pattern that will repeat after an appropriate interval, eg use the day of the week in the filename if you wanted seven daily log files. regards, tom lane
Tom Lane wrote: > Steve Clark <sclark@netwolves.com> writes: > >>I have postgres logging into data/pg_log/ which works great. My question is there >>and option that tells postgres to only keep the last "n" log files? > > > The usual solution is to choose a filename pattern that will repeat > after an appropriate interval, eg use the day of the week in the > filename if you wanted seven daily log files. > > regards, tom lane > > Great, Thanks Tom.