Обсуждение:

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.

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