As suggested, i had changed the log_statement='ddl' and now it is logging only the ddl statements . thanks for the tip. Can i delete the old log files in pg_log after backing up as zip archive ? is it neccesary to keep those log files ?
Regards Shiva Raman > > 2009/9/25 Grzegorz Jaśkiewicz <gryz...@gmail.com> > > On Fri, Sep 25, 2009 at 9:06 AM, Shiva Raman <raman.shi...@gmail.com>wrote: > >> Hi Gerhard >> I also found the pg_log has 73 G of data . >> >> clusternode2:/var/lib/pgsql/data # du -sh pg_log/ >> 73G pg_log/ >> >> Is it necessary to keep this Log files? Can i backup the logs and delete >> it from the original directory ? Is this logs files necessary in case any >> data recovery to be done ? >> I am database dumps every day . >> > you're probably logging too much. Change level of logging (log_statement to > ddl for instance), and do 'pg_ctl reload' > > > > -- > GJ >
