From: | "Mensinger, Oliver" <Oliver(dot)Mensinger(at)rossmann(dot)de> |
---|---|
To: | <zz_11(at)mail(dot)bg>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: How to restore updated records |
Date: | 2007-06-12 11:53:20 |
Message-ID: | A5AC26D2F3B3CB42A3BCB88965C9343902D787CD@sv-7.intern.rossmann.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Ivan,
if you have configured WAL archiving, you may want to look at http://www.postgresql.org/docs/8.1/static/backup-online.html, especially paragraph '23.3.4. Timelines'.
List: Maybe someone already hacked the postmaster to extract deleted records?!
HTH, Oliver.
-----Ursprüngliche Nachricht-----
Von: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] Im Auftrag von zz_11(at)mail(dot)bg
Gesendet: Montag, 11. Juni 2007 19:35
An: pgsql-admin(at)postgresql(dot)org
Betreff: [ADMIN] How to restore updated records
Hi all.
Sorry for my problem.
I am using pg on ~100 servers fro 5 y. without any problems,
but this time I make a big mistake.
A have a table tasks with about 20000 records.
The table have ID as pk and some other fields.
I typed : update tasks set c1='sss';
instead update tasks setc1='sss' where id=10;
And the pg updated all my table tasks.
I do not have any backup on this table.
Exists any way to restore the data>
After the mistake I stopped to execute any commands to this
database and also I DO NOT HAVE running vacuum, vacuum
analyze ot vacuum full analyze on this table.
I know pg stores the old copy of data, but I do not have any
idea how to restore this deleted records.
Pls., point me to any solution for this problem.
Many thanks and best regards,
ivan.
-----------------------------
SCENA - Единственото БЕЗПЛАТНО списание за мобилни комуникации и технологии.
http://www.bgscena.com/
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2007-06-12 16:02:27 | Re: Postgresql - Windows platform |
Previous Message | Jayakumar_Mukundaraju | 2007-06-12 08:34:18 | Postgresql - Windows platform |