akp geek <akpgeek@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
