From: Pallav Kalva <pkalva@deg.cc>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Postgres Log rotation not working in 8.0.2
Date: Mon, 18 Apr 2005 15:24:45 -0400
Message-ID: <4264097D.7090808@deg.cc> (raw)
Hi Everybody,
Postgres log rotation doesnt seem to behave properly, below are
the settings which I used for log rotation. I want the postgres log to
be rotated every week , its past over a week now and it still writing to
the old log. Are these settings right for what I want to achieve ? or am
I missing something ? Please advice, we are planning to go production
soon and dont want to change my settings later.
TIA,
Pallav
#---------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#---------------------------------------------------------------------------
# - Where to Log -
#log_destination = 'stderr' # Valid values are combinations of stderr,
# syslog and eventlog, depending on
# platform.
# This is relevant when logging to stderr:
redirect_stderr = true # Enable capturing of stderr into log files.
# These are only relevant if redirect_stderr is true:
log_directory = '/var/lib/pgsql/pg_log' # Directory where log files
are written.
# May be specified absolute or relative to
PGDATA
log_filename = 'postgresql-%U.log' # Log file name pattern.
# May include strftime() escapes
log_truncate_on_rotation = true # If true, any 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 false, meaning append to existing
# files in all cases.
log_rotation_age = 10080 # Automatic rotation of logfiles will happen
after
# so many minutes. 0 to disable.
log_rotation_size = 0 # Automatic rotation of logfiles will happen
after
# so many kilobytes of log output. 0 to
disable.
# These are relevant when logging to syslog:
#syslog_facility = 'LOCAL0'
#syslog_ident = 'postgres'
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: pkalva@deg.cc
Subject: Re: Postgres Log rotation not working in 8.0.2
In-Reply-To: <4264097D.7090808@deg.cc>
References: <4264097D.7090808@deg.cc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox