Обсуждение: Recover databases from raw files (only exists the base directory)

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

Recover databases from raw files (only exists the base directory)

От
Carlos Martinez
Дата:
Hi.

I have  been contacted for this interesting issue: on a standalone  postgresql 9.4 server someone deleted all PostgreSQL files and directories  except the base directory and its content (/var/lib/pgsql/9.4-base/data/base).

So, the question is: there is any chance/procedure to recover the databases?

As usual, the last backup has "a few" weeks. So, this dump can be used to recover the recent data?

Thanks a lot for you help.

Carlos Martínez.

Re: Recover databases from raw files (only exists the basedirectory)

От
Laurenz Albe
Дата:
Carlos Martinez wrote:
> I have  been contacted for this interesting issue: on a standalone  postgresql 9.4
> server someone deleted all PostgreSQL files and directories  except the base directory
> and its content (/var/lib/pgsql/9.4-base/data/base).
> 
> So, the question is: there is any chance/procedure to recover the databases?
> 
> As usual, the last backup has "a few" weeks. So, this dump can be used to recover the recent data?

I'd cut the losses and take the backup.

You'd need a specialist to recover anything there.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com