On Wed, Oct 23, 2013 at 9:10 PM, Jayadevan M <maymala.jayade...@gmail.com>wrote:
> Hi, > I went through > http://www.postgresql.org/docs/9.3/static/continuous-archiving.html > and set up the archiving process. With this approach, if my database > crashes after a couple of weeks after the base backup is taken, recovering > would mean replaying the WAL logs for about 2 weeks, right? To avoid that, > what is the standard process followed - take a base backup every day or > once a week? > Regards, > Jayadevan > I restore from my base backup plus WAL quite often. It is how I get a fresh dev or test instance when I want one. (It is also how I have confidence that everything is working well and that I know what I'm doing should the time come to do a real restore). When that starts to take an annoyingly long time, I run a new base backup. How often that is, can be anywhere from days to months, depending on what's going on in the database. Cheers, Jeff
