PostgreSQL Restore Database Without Backup and Log

On 01/26/2018 05:58 AM, fabio.silva wrote:

Hi!
I had a Ransomware atack and I lost a lot of file from my server.
I just have the OID folder and the files inside it.
Is it possible restore database using only this data files?

I am going to say no, too much information is missing to reconstruct the
cluster.

I don't have the folder data, I don't have the folder global, I just have
Datafiles from my old database.
I'm using PostgreSQL 9.4 and Windows Server 2012R2
Thanks!

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

--
Adrian Klaver
adrian.klaver@aklaver.com

Adrian Klaver <adrian.klaver@aklaver.com> writes:

On 01/26/2018 05:58 AM, fabio.silva wrote:

I had a Ransomware atack and I lost a lot of file from my server.
I just have the OID folder and the files inside it.
Is it possible restore database using only this data files?

I am going to say no, too much information is missing to reconstruct the
cluster.

There are various PG support companies that specialize in data recovery
after filesystem failures, and it's possible that one of them could help
in getting at least some data back from this situation. It likely won't
be cheap though. There's definitely no easy, certain-to-work answer.

regards, tom lane