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: [email protected]
