Add configurable log rotation for PostgreSQL

[to-bar]

By default, on RHEL there is weekly log rotation (without size limit) handled by PostgreSQL logging collector and on Ubuntu it's logrotate configured like below:

/var/log/postgresql/*.log {
       weekly
       rotate 10
       copytruncate
       delaycompress
       compress
       notifempty
       missingok
       su root root
}

Additional info:
https://www.postgresql.org/docs/current/logfile-maintenance.html
https://dba.stackexchange.com/questions/159528/in-postgres-set-log-rotation-size-but-my-logs-are-still-not-rotating