Re: wal archiving question

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> akp geek <akpgeek(at)gmail(dot)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
>