From: | zz_11(at)mail(dot)bg |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | How to restore updated records |
Date: | 2007-06-11 17:35:06 |
Message-ID: | 1181583306.d9d10231a3c6c@mail.bg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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/
From | Date | Subject | |
---|---|---|---|
Next Message | jbar | 2007-06-11 23:52:09 | Re: problems installing postgresql 8.0 on Mac OS |
Previous Message | Josh | 2007-06-11 16:52:04 | Binaries of PGAdmin3 for RHEL5 |