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

From: Carlos Martinez <camarti(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Recover databases from raw files (only exists the base directory)
Date: 2019-10-24 16:55:59
Message-ID: CA+Mn-VanapsD8P4CW5CYyE7JSedy1fPyJ-_bKDbVwGC5u0gqVA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Morris 2019-10-24 17:04:47 Re: Lookup Primary Key of Foreign Server's Table
Previous Message Adrian Klaver 2019-10-24 16:45:44 Re: Search path