3 ms·
Is anybody using a procedure to automatically perform restores and check that they match production data? I guess it's not easy for complex systems and non triv
by pmontra 10y ago
Is anybody using a procedure to automatically perform restores and check that they match production data? I guess it's not easy for complex systems and non trivial amounts of data. Do you want to share the details and give us an idea of the costs? Thanks.
- paktek123 10y agoI've setup a postgresql backup before that would use pgbasebackup and get the latest xlog segments then I would start up postgres and run select 1 against it. That simply wasn't enough as I still got corrupted indexes but at least data was there. If I were to do it again I'd probably run a whole production test suite against it. The cost is extra hardware and time as backup boxes aren't made for performance for a 1Tb+ database it would take more than 24 hours.