On Fri, Sep 25, 2009 at 9:06 AM, Shiva Raman <raman(dot)shivag(at)gmail(dot)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