I have logrotate set up for my databases, the problem is that I alwayz
have to restart my server after the log file is rotated.
What do I do after the logrotate so I don't have to restart the db
server?
The ways I've tried to start the server:
pg_ctl start -D .../data -l logfile
and
pg_ctl start -D .../data | cat - >> logfile
At the moment, I'm using the logrotate script that comes with redhat.
I basically just had to create a logrotate.conf file and use it to
logrotate.