Re: Postgres Dropped DB have recovered files how to restore

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres Dropped DB have recovered files how to restore
Date: 2016-06-07 00:40:26
Message-ID: b4b0789a-2cc2-b13d-b5b9-dbd2331057e8@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6/6/2016 4:09 PM, Alvaro Herrera wrote:
> I have no idea about Windows filesystems but you may be able to
> "undelete" the files, as long as you don't touch the partition for
> anything else; search the web for "undelete ntfs". Once you undelete
> you will need to put them back in the right places. I suggest you get a
> disk with twice as much space as the original; make an image copy of the
> original disk and don't touch the original anymore. Then try to
> undelete the files from the image. Use the list Adrian provided as a
> guide for what you're missing.
>
> You*may* be able to recover the data, if you're lucky and careful.

that won't work if he did a DROP DATABASE as all the metadata is gone.

--
john r pierce, recycling bits in santa cruz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sridhar N Bamandlapally 2016-06-07 03:37:45 Re: [HACKERS] OUT parameter and RETURN table/setof
Previous Message Patrick B 2016-06-07 00:32:13 Re: Re-sync slave server