/var/log/postgresql {
    postrotate
      /etc/rc.d/rc.postgresql reload 2>&1 > /dev/null
    endscript
    size=100k
    rotate 5
    create 0640 postgres wheel
}