| From: | Ivan <kuzma(dot)wm(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | undo update |
| Date: | 2012-03-15 14:22:25 |
| Message-ID: | CAHJkLEvb8aOvrK0e9ECSsOY7RHKthts9FJ3mZ-PwjtsJBZGZuw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all.
Today an accident happened on one of my databases. I have a table named
"payments" with about 5400 rows. I have done a query "update payments set
amount = 0; where id in (2354,2353,1232)". Please note the semicolon inside
— I missed it =(
Now all my data is lost. And after this happened I realized that backups
script is broken (my fault, I know)
I googled a little and have found that there is a chance to restore my data
using files in pg_xlog directory. But everybody say about PITR and I don't
use it. Also there is a xlogviewer project (from old 2006) that I'm trying
to install on my Gentoo right now.
I copied all PGDATA directory and made a dump of all databases. Also I
turned off my webserver. Postgres is still running.
Please give me some step-by step guide what should I do next? Is there any
chance to restore my data?
I use postgresql 8.4 with default config (autovacuum is commented)
--
______________________________
Yours sincerely, Ivan Kuznetsov aka Kuzma
mailto: kuzma(dot)wm(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2012-03-15 14:25:15 | Re: Backups |
| Previous Message | Andrey Chursin | 2012-03-15 13:15:29 | Fetch from cursor with indexed sorting |