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 <t...@sss.pgh.pa.us> wrote: > akp geek <akpg...@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 >
