From: zz_11@mail.bg
To: pgsql-admin@postgresql.org
Subject: How to restore updated records
Date: Mon, 11 Jun 2007 20:35:06 +0300
Message-ID: <1181583306.d9d10231a3c6c@mail.bg> (raw)
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: zz_11@mail.bg
Subject: Re: How to restore updated records
In-Reply-To: <1181583306.d9d10231a3c6c@mail.bg>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox