Toggle navigation
Type: integer
Default: 1440
Min: 0
Max: 35791394
Unit: minutes (min)
Context: sighup
Restart: false

When logging_collector is enabled, this parameter determines the maximum amount of time to use an individual log file, after which a new log file will be created. If this value is specified without units, it is taken as minutes. The default is 24 hours. Set to zero to disable time-based creation of new log files. This parameter can only be set in the postgresql.conf file or on the server command line.

Recommendations

1d is generally good for production. Set to 1h to rotate logs hourly when doing performance analysis.

Comments