1

I’m using Postgres 9.5 on Ubuntu 14.04. I notice I’m generating a lot of Postgres logs in

/var/log/postgresql/postgresql-9.5-main.log

. I would like to limit the size of this file, and doing some time based rotation (e.g. daily) is not an option. Is there any way I can tell Postgres to rotate its logs once they reach a certain size?

2

The PostgreSQL Error reporting and logging documentation states:

log_rotation_size (integer)

When logging_collector is enabled, this parameter determines the maximum size of an individual log file. After this many kilobytes have been emitted into a log file, a new log file will be created. Set to zero to disable size-based creation of new log files. This parameter can only be set in the postgresql.conf file or on the server command line.

So, I guess you should set this parameter to the desired value. My postgresql.conf option has the default values:

#log_rotation_size = 10MB       # Automatic rotation of logfiles will  
                # happen after that much log output.  
                # 0 disables.  
  • I set this but it is still not rotating the logs .. maybe I there is something else I need to do besides restarting the PostGres server? – Dave Dec 29 '16 at 23:39
  • 1
    Is logging_collector enabled ? – joanolo Dec 30 '16 at 18:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.