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.