Recover databases from raw files (only exists the base directory)
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.
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