How to restore updated records
| От | zz_11@mail.bg |
|---|---|
| Тема | How to restore updated records |
| Дата | |
| Msg-id | 1181583306.d9d10231a3c6c@mail.bg обсуждение |
| Список | pgsql-admin |
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/
В списке pgsql-admin по дате отправления: