Hi,
I want to show that postgresql, while is recovering the database applying the WAL file, don't raise any error if it can't find a missing file. It continue the recovery that end successfully. I know that the source of the problem is that I have to guarantee that the backup is complete and consistent but it sound me strange that postgresql don't signal any errors when it can't find a file .... I hope that is clear the scope of the testcase.
Thanks & Regards
Gabriele
Il 10 gennaio 2018 alle 18.04 Rui DeSousa <rui.desousa@icloud.com> ha scritto:
You’ve just corrupted your system… not sure what you actually trying to reproduced.
10) Delete of the file containg the table "test_corrupt" to simulate the file missing in the backup:
What is being used to backup the files? What are your file system mount options? Sound’s like your backup is not backing up all the files.
10) Delete of the file containg the table "test_corrupt" to simulate the file missing in the backup: