/var/log/postgresql {
    daily
    rotate 7
    copytruncate
    delaycompress
    compress
    notifempty
    missingok
}