Another day, another recovery
Posted Tuesday Feb 14th, 2012 03:01pm
by Alvaro Herrera | Permalink

This is something I have seen many times now: a customer calls us because they lost some data and they want help recovering.

Now you must be wondering: surely if they lost data they can just recover from their last backup, right? Right — they had that. However we know that pg_dump takes a while to run and is stressful on the server, so it's normally run just once a day or so. What happens if you've been running almost a full work day since your last backup? It's a lot of data to lose.

Read more...

---

blog comments powered by Disqus