Re: Log File Maintainance

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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83