My pgbouncer.log grows endlessly.
How do I enable filename rollover or limit the logfile size for pgbouncer on Ubuntu?
asked Dec 12, 2016 at 9:51
1 Answer
Until now, pgBouncer doesn't support rotate log. Hence, you have to do it by yourself.
You can refer to sites below:
answered Dec 12, 2016 at 10:33
-
1I used
logrotateto take care of it. But there's still a problem, perhaps you can help? After changing the desired logging level tosize 100M, I forced logrotate vialogrotate -f. As a result of that, I'm seeing: error writing to /var/log/postgresql/pgbouncer.log.1: No data available. I.e log rotation has failed! When I dotail -f pgbouncer.log, I see a ton of log lines being generated in real time, so logging is still going on, but logrotation thinks there'sno data available. What to do!? Dec 12, 2016 at 10:58 -
-
How about your
pgbouncer.logconfiguration file? (linuxcommand.org/man_pages/logrotate8.html) . Please test before applying to production env. Dec 12, 2016 at 11:10 -
In
pgbouncer.ini(the configuration file), I can only configure the location of the log files, not their rotation credentials. Dec 12, 2016 at 11:27 -
pgbouncer.logas this blog: raghavt.blogspot.com/2016/08/…. it is notpgbouncer.iniDec 12, 2016 at 12:35
rotateon Linux to do that. (rotate by date & size).pgbouncer.inior something? Would appreciate the details.pgbouncer.inito rotate logs becausepgBouncerdidn't support rotate logs (asPostgreSQL). That's why we had to userotate log of Linux. In terms ofrotate log Ubuntu, in fact, I didn't remember in details, however, please review digitalocean.com/community/tutorials/… , I think that web can help you.