Re:

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