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
