Recovery data base!!

Started by Elson Vazover 7 years ago3 messagesgeneral
Jump to latest
#1Elson Vaz
elsonlei@gmail.com

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 .

#2Pavan Teja
pavan.postgresdba@gmail.com
In reply to: Elson Vaz (#1)
Re: Recovery data base!!

Hi Elson,

Do you have the latest basebackup/filesystem backup of the instance?

If yes you can recover to the backups taken time.

Regards,
Pavan

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

#3Andreas Kretschmer
andreas@a-kretschmer.de
In reply to: Elson Vaz (#1)
Re: Recovery data base!!

On 7 November 2018 06:13:20 CET, Elson Vaz <elsonlei@gmail.com> wrote:

Hello people,

I need a lot of help,

Accidentally I deleted all the files from the database,
...
I have also back up the complete database directory for a month.

Install the latest backup. Consider a better backup procedure for the future.

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company