Thread: Recovery data base!!

Recovery data base!!

From
Elson Vaz
Date:
Hello people,

I need a lot of help,

Accidentally I deleted all the files from the database, the last copy that I have a day late.
I tried with R studio to recover the files, but some files are not correct / corrupted.
I have also back up the complete database directory for a month.
The postgres I have is 9.4, and the OS is RedHat

Can someone help me .

Re: Recovery data base!!

From
Alex Balashov
Date:
On Tue, Nov 06, 2018 at 11:55:14PM -0600, Ron wrote:

> What do you mean by "the last copy that I have a day late"?

I think he means that it's a day old, and that's too old - he wants some
sort of PITR from a more recent point than a restore of the most recent
daily backup would provide.

-- 
Alex Balashov | Principal | Evariste Systems LLC

Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free) 
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/


Re: Recovery data base!!

From
Ron
Date:
On 11/06/2018 11:12 PM, Elson Vaz wrote:
Hello people,

I need a lot of help,

Accidentally I deleted all the files from the database, the last copy that I have a day late.

What do you mean by "the last copy that I have a day late"?

I tried with R studio to recover the files, but some files are not correct / corrupted.
I have also back up the complete database directory for a month.
The postgres I have is 9.4, and the OS is RedHat

Can someone help me .

--
Angular momentum makes the world go 'round.