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