| From: | Jona <jonanews(at)orioninformationservices(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Recover old record version |
| Date: | 2004-08-11 13:45:47 |
| Message-ID: | 411A230B.4030405@orioninformationservices.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
One of our developers has just managed to make an UPDATE on a table
without any WHERE clause to restrict it.
Thus a table with a few thousand records has suddenly become virtual
identical.
Currently no VACUUM has been run on that table (or the database for that
matter) thus it should be possible to recover an old version of the
records, right?
I'm basing my assumption on the documentation which states that PostGre
has better than row-level locking and keeps an old version of each
record until a vacuum occours.
How would I go about recovering one of the old version for all the
records ??
Please advice!
Cheers
Jona
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Darren Sunley | 2004-08-11 17:02:04 | dynamic DB descriptions |
| Previous Message | Martin J. Brown, Jr. | 2004-08-11 10:17:27 | can't authenticate pg admin |