No title

On Tue, 2010-02-23 at 13:50 -0500, Shu Ho wrote:

All

do you clean up the server file by removing them
use

find $logfile -mtime +$NUMBER_DAYS_TO_KEEP -type f -print -exec rm -f
{} \;

in postgres ?

How to remove the archive log files in postgres ? is the same way as
remove backup files and server log files ?

thanks
Amy

______________________________________________________________________
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. Sign up
now.

google logrotate
man logrotate

Shu Ho wrote:

do you clean up the server file by removing them
use

find $logfile -mtime +$NUMBER_DAYS_TO_KEEP -type f -print
-exec rm -f {} \;

in postgres ?

I do it similarly, but I don't use "-exec", I rather pipe the results
of find into something like "xargs rm -f" for better performance.

How to remove the archive log files in postgres ? is the same
way as remove backup files and server log files ?

Yes.

Just make very sure that you don't delete any archived WAL files
that you might still need - say, to resort to an older backup if
your most recent backups failed or the tape got eaten by mice
or whatever.

Yours,
Laurenz Albe