Description:
PostgreSQL doesn't have a logrotate config so the log files can get pretty large.

Additional info:
* postgresql 8.4.4-1

Here is a simple one:
/var/log/postgresql.log {
copytruncate
delaycompress
missingok
notifempty
}