Re: Issue on restore / recover - Mailing list pgsql-admin

From flumbador@virgilio.it
Subject Re: Issue on restore / recover
Date
Msg-id 326066541.973171.1515753625461@mail.virgilio.it
Whole thread Raw
In response to Re: Issue on restore / recover  (Rui DeSousa <rui.desousa@icloud.com>)
Responses Re: Issue on restore / recover  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-admin

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.


On Jan 10, 2018, at 11:28 AM, flumbador@virgilio.it wrote:

10) Delete of the file containg the table "test_corrupt" to simulate the file missing in the backup:


pgsql-admin by date:

Previous
From: Dutchglory
Date:
Subject: Re: minor: "-i" option not supported pgsql 10.xx on website...
Next
From: Marcelo Beccari
Date:
Subject: Re: Please remove me from the mailing list....