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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von [EMAIL PROTECTED] Gesendet: Montag, 11. Juni 2007 19:35 An: pgsql-admin@postgresql.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? http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
