I'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. T

I'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.