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
Read the man page(s) for details.
--
Richard Huxton
Archonet Ltd