| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Marek Nowiński <marek(dot)nowinski(at)medycynarodzinna(dot)pl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: HELP |
| Date: | 2004-07-09 07:03:07 |
| Message-ID: | 40EE432B.5020505@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Marek Nowiński wrote:
> I accidentaly deleted over 1.000.000 records from one table in my
> database. Is there any way to recover them? Please help me as soon
> as possible...
>
> After the records were deleted, no other operation was made on the
> database. In fact, all the postgres services were shut down.
> I found a xlog file containing those records but I don't know the
> structure of this file.
> This is Postgres 7.2.1 on Mandrake 8.1
Well - you'll probably need to wait until a developer can make a
suggestion to get your data back. However, I do know enough to say that
your data will still be there - so long as no further action takes place
you'll be alright.
You'll probably want to take a backup of your whole .../data/ directory
to be on the safe side. At a guess, it might be enough to rewind your
current transaction-id and pg_dump that table, but I'm really out of my
depth here.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Mueller | 2004-07-09 07:27:42 | Re: Column name 'user' not allowed? |
| Previous Message | Bret Busby | 2004-07-09 06:30:04 | Training and certification |