Обсуждение: Database logging.... Recycle server logs ???
I recently discovered that another programmers CGI's are occasionally killing my postgreSQL server so I decided to modify the postgres.conf file to do some extended logging and additionally redirect the server output into an error log (using the -l pgdblog.log) switch... postgreSQL was restarted like this: > pg_ctl start -D /usr/bin/pgsql/data -l pgdblog.log I noticed that the server generated logfile gets real big real fast -- (15 queries and it's already at 1.5MB) -- Is there a switch / option to recycle the server logs periodically ??? TIA... GP
"codeWarrior" <GPatnude@adelphia.net> writes: > I noticed that the server generated logfile gets real big real fast -- (15 > queries and it's already at 1.5MB) -- Is there a switch / option to recycle > the server logs periodically ??? The recommended procedure is not to use pg_ctl's -l switch, but to pipe output from it into a log-rotating script. The rotatelogs script from the Apache distribution works well, or you can roll your own. See http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/logfile-maintenance.html regards, tom lane
"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message news:4864.1042488639@sss.pgh.pa.us... > "codeWarrior" <GPatnude@adelphia.net> writes: > > I noticed that the server generated logfile gets real big real fast -- (15 > > queries and it's already at 1.5MB) -- Is there a switch / option to recycle > > the server logs periodically ??? > > The recommended procedure is not to use pg_ctl's -l switch, but to pipe > output from it into a log-rotating script. The rotatelogs script from > the Apache distribution works well, or you can roll your own. See > http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/logfile-maintena nce.html > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org Thanks Tom -- Of course -- I located that section of the manual immediately after my post... I will use logrotate....