PostgreSQL – Log Rotation Configuration

logspostgresql

In postgresql, I'm using the following configuration to maintain my weekly logs:

log_truncate_on_rotation = on
log_rotation_age = 1d
log_filename = 'postgresql-%a.log'
log_rotation_size = 0  #just rotate daily

This creates a log file with a name like 'postgresql-Mon.log' and when rotation occurs, it overrides the old file with the same name. This way I'm able to maintain a weekly log.

I now want to move this configuration to keeping the log for just one day, instead of 7 days. How do you suggest I tweak the config given above to achieve this? Do I only need to change the log_filename to postgresql.log? Please advise. Thanks in advance.

Best Answer

Yes, as (like you described) rotation replaces the file with the same name, you can find whichever name you like, without any daily changing bits.

Related Solutions

Postgresql – Unable to disable SQL statement logging in PostgreSQL 9.1

There are a number of relevant settings missing in your list. Check the chapter "When to log" in the manual, in particular these settings:

log_min_messages (enum)
log_min_error_statement (enum)
log_min_duration_statement (integer) -- as @Jack already hinted in his comment.

Postgresql – Postgres log files not rotating

Try the following log parameters. After modify them, remember to reload the configuration file ($PGDATA/postgresql.conf).

# These are only used if logging_collector is on:
log_directory = '/var/applog/pg_log/1921'               # 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 = 0600                    # creation mode for log files,
                                        # begin with 0 to use octal notation
log_truncate_on_rotation = on           # 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.
log_rotation_age = 1d                  # Automatic rotation of logfiles will
                                        # happen after that time.  0 disables.
log_rotation_size = 10MB               # Automatic rotation of logfiles will

Best Answer

Related Solutions

Postgresql – Unable to disable SQL statement logging in PostgreSQL 9.1

Postgresql – Postgres log files not rotating

Related Question