How To Build Log Rotation Change File Log 1Day With Different File And Show Date Time Log On Postgresql

dba@dba-rizky:~$ ssh root@x.x.x.x

root@x.x.x.x's password:

Last login: Thu Apr 19 16:54:32 2018 from dba

[root@prod-odgpostgres ~]# su - postgres

[postgres@prod-odgpostgres ~]# cd /DATA

[postgres@prod-odgpostgres DATA]# vi postgresql.conf

(+) change line here.

# - Where to Log -

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 = 'logs' # directory where log files are written,

# can be absolute or relative to PGDATA

log_filename = 'MARMER_PURI_AGUNG-%Y-%m-%d.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 = 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.

log_rotation_age = 1d # Automatic rotation of logfiles will

# happen after that time. 0 disables.

#log_rotation_size = 10MB # Automatic rotation of logfiles will

# happen after that much log output.

# 0 disables.

log_line_prefix = '%t [%p] %a %u %d %r %e'

after finished save and stop postgres and start again, you must start 4 second or 5 second dont time to long your start after stop.

[postgres@prod-odgpostgres DATA]#/usr/local/pgsql/bin/pg_ctl stop -D /DATA

[postgres@prod-odgpostgres DATA]#/usr/local/pgsql/bin/pg_ctl start -D /DATA