Your best bet on something like this is probably going to be
contacting a company that does PostgreSQL support and inquiring about
data recovery. EnterpriseDB and Command Prompt both employ folks who
could probably accomplish this; I think OmniTI might as well. There's
probably a few others.
On Jun 12, 2007, at 11:19 AM, zz_11@xxxxxxx wrote:
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/
---------------------------(end of
broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
--
Jim Nasby jim@xxxxxxxxx
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
