Re: PostgreSQL Point In Time Recovery

Jeff Janes wrote
> 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

That makes sense. So we take a new base backup once we feel "Hey , recovery
may take time". Thanks.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/PostgreSQL-Point-In-Time-Recovery-tp5775717p5775872.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.