Thread: PostgreSQL Restore Database Without Backup and Log

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 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

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