Comprehensive data protection for all workloads
Post Reply
jirkava
Novice
Posts: 4
Liked: never
Joined: Oct 21, 2011 1:41 pm
Full Name: Jiri Vana
Contact:

PostgreSQL log files rotation

Post by jirkava »

VBR 12.0.0.1420 P20030718
In the C:Program FilesPostgreSQL15datalog folder, files are constantly being added and have not been deleted for several months (since upgrade to v12).
There is 6136 files, sum 60GB.

What should I set to make PostgreSQL automatically delete log files?

There's this setting, but it doesn't work.
postgresql.conf


#------------------------------------------------------------------------------
# REPORTING AND LOGGING
#------------------------------------------------------------------------------

# - Where to Log -

log_destination = 'stderr' # Valid values are combinations of
# stderr, csvlog, jsonlog, syslog, and
# eventlog, depending on platform.
# csvlog and jsonlog require
# logging_collector to be on.

# This is used when logging to stderr:
logging_collector = on # Enable capturing of stderr, jsonlog,
# and csvlog into log files. Required
# to be on for csvlogs and jsonlogs.
# (change requires restart)

# These are only used if logging_collector is on:
#log_directory = '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_file_mode = 0640 # creation mode for log files,
# begin with 0 to use octal notation
log_rotation_age = 10d
# happen after that time. 0 disables.
#log_rotation_size = 10MB # Automatic rotation of logfiles will
# happen after that much log output.
# 0 disables.
#log_truncate_on_rotation = off # If on, an existing log file with 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.
[/size][/size]
rovshan.pashayev
Veeam Software
Posts: 260
Liked: 42 times
Joined: Jul 03, 2023 12:44 pm
Full Name: Rovshan Pashayev
Location: Czechia
Contact:

Re: PostgreSQL log files rotation

Post by rovshan.pashayev »

Hello,

Try to alter log rotation values, example log_rotation_size, and restart the service.

Rovshan.
Rovshan Pashayev
Analyst
Veeam Agent for Linux, Mac, AIX & Solaris
Post Reply

Who is online

Users browsing this forum: jie.yan and 128 guests