Re: wal archiving question

akp geek <akpgeek@gmail.com> writes:
> thank you all. There is a mistake I did then. I created a base backup when
> I started the DB , that was exactly an year ago. I need to do that again
> and then delete the old files.

Yeah, you should be making new base backups a lot more frequently than
that, probably.  Consider: if your DB died today and you had to restore
from the base backup, you'd have to replay a year's worth of WAL to get
back where you were.  That'd take ages.  So the bloat in the archive
directory is just one reason not to do it like that.

            regards, tom lane