| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | "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:41:38 |
| Message-ID: | 29346.1517168498@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igal @ Lucee.org | 2018-01-28 19:56:03 | pg_trgm Extension Installed but Operators and Functions do not exist |
| Previous Message | Adrian Klaver | 2018-01-28 19:30:48 | Re: PostgreSQL Restore Database Without Backup and Log |