Re: Recover databases from raw files (only exists the basedirectory) - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Recover databases from raw files (only exists the basedirectory)
Date
Msg-id 14cc3f597bb2b4fc8067fda28db352a08e8cc54f.camel@cybertec.at
Whole thread Raw
In response to Recover databases from raw files (only exists the base directory)  (Carlos Martinez <camarti@gmail.com>)
List pgsql-general
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




pgsql-general by date:

Previous
From: Chris Morris
Date:
Subject: Re: Lookup Primary Key of Foreign Server's Table
Next
From: Laurenz Albe
Date:
Subject: Re: jsonb_set() strictness considered harmful to data