Re: How safe is pg_basebackup + continuous archiving?

>
> Before replaying a backup on a production system, you would need a
> pre-production setup where the backup is replayed and checked.
> Honestly, you can only be sure that a backup is working correctly
> after reusing it. You could always do some validation of the raw
> backup contents, but you need at the end the WAL applied on top of it
> to be able to check the status of a server that has reached a
> consistent point.
>

Could you elaborate a bit more on this last part? If a PostgreSQL recovery
from a pg_basebackup reaches a consistent point and is able to start up
fully, that is not a guarantee that there hasn't been any underlying
corruption, as far as I know. Am I correct on this?

Thanks once again.

Kaixi