Re: Issue on restore / recover

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(dot)desousa(at)icloud(dot)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.
>
>
>
> > > On Jan 10, 2018, at 11:28 AM, flumbador(at)virgilio(dot)it mailto:flumbador(at)virgilio(dot)it wrote:
> >
> >
> > 10) Delete of the file containg the table "test_corrupt" to simulate the file missing in the backup:
> >
> >
> > >
>