Re: PostgreSQL Restore Database Without Backup and Log

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: "fabio(dot)silva" <fabio(dot)ferreiras(at)yahoo(dot)com(dot)br>, pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL Restore Database Without Backup and Log
Date: 2018-01-28 19:30:48
Message-ID: 60ee530f-6529-bacd-b0e4-decf08324a40@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-01-28 19:41:38 Re: PostgreSQL Restore Database Without Backup and Log
Previous Message Rob Sargent 2018-01-28 19:22:03 Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP