Re: big problem

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Bostjan Potocnik <bostjan(at)idejaplus(dot)si>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: big problem
Date: 2005-02-22 14:50:46
Message-ID: 421B46C6.9010205@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> I deleted valuable data from wrong table :) pretty common problem i
> think. Guy on #postgresql at freenode told me that my data is still
> there, but tricky part is how to undo my delete. I'm using pg 7.4.7 on
> fbsd, i dont' use any special config and pg_xlog is fine. I hope there
> is a solution :)

That guy on IRC is probably me. I told him to take a copy of his data
dir for safekeeping, and not to vacuum. I don't know how to get a look
at old row versions, however. It's new data with no backup, and no PITR
running.

Chris

In response to

  • big problem at 2005-02-22 14:47:18 from Bostjan Potocnik

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-02-22 15:32:23 Re: Get rid of system attributes in pg_attribute?
Previous Message Bostjan Potocnik 2005-02-22 14:47:18 big problem