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@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] Im Auftrag von zz_11@xxxxxxx Gesendet: Montag, 11. Juni 2007 19:35 An: pgsql-admin@xxxxxxxxxxxxxx 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
