Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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/




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group