logging - psql 9.1 reset size of the postgresql log file -


my log file (postgresql-9.1-main.log) size use 3g before rotation fews days ago started 70g. did not change anything.

pg_lsclusters    version cluster   port status owner    data directory                     log file    9.1     main      5432 online postgres /var/lib/postgresql/9.1/main       /var/log/postgresql/postgresql-9.1-main.log    

so log not managed postgresql, package since line related logging commented out.

is possible postgresql common relies on logrotate? how can reset size of log file 3g?

just had go /etc/logrotate.d/postgresql-common , make changes.

/var/log/postgresql/*.log {    daily        <----change weekly daily.    rotate 31    copytruncate    delaycompress    compress    notifempty    missingok }     

Comments