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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
