No, I do not have WAL archiving. I hope some one have done the hacking in postmaster. If no one have done this, my idea was to change the vacuum (or make e new copy). I am not familiar with pg code, but as I know by running vacuum, pg marks deleted records as free, and my idea was to mark this records as real record in the database (if it is possible). regards, ivan. > 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. > > -----Ursprungliche 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 > > ---------------------------(end of > broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by > donating at > > http://www.postgresql.org/about/donate > > > ----------------------------- SCENA - Единственото БЕЗПЛАТНО списание за мобилни комуникации и технологии. http://www.bgscena.com/
