Обсуждение: Recovery data base!!

Поиск
Список
Период
Сортировка

Recovery data base!!

От
Elson Vaz
Дата:
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!!

От
pavan95
Дата:
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


Re: Recovery data base!!

От
Andreas Kretschmer
Дата:
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