On Tue, 12 Apr 2005, Richard Huxton wrote:
Inpreet Singh wrote:Hello, I am working on live server where we have installed postgres database as our back end. But now the problem is due to continues work on postgres, size of log files has become problem for us. And the partition where our postgres exists is full. Postmaster is not working now. I tried to rotate log file by adding lines in postgresql.conf **************************************************** syslog = 2 # range 0-2 syslog_facility = 'LOCAL0' syslog_ident = 'postgres'
You also need to update your syslog.conf and restart syslogd
Add a line like: local0.* /var/log/pgsql
probably, better -/var/log/pgsql
Read the man page(s) for details.
Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
