Re: wal archiving question

[akp geek <akpgeek@xxxxxxxxx>]

thank you so much for all the inputs.. One final question is , Do we have to stop the database when we create the base backup?

Regards

On Wed, Dec 5, 2012 at 4:45 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

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