Search Postgresql Archives

8.3.x log maintenance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux