| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | John Sidney-Woollett <johnsw(at)wardbrook(dot)com> |
| Cc: | Venki <Venki(at)insoft(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Disappearing Records |
| Date: | 2005-11-02 11:09:33 |
| Message-ID: | 20051102110930.GB19550@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Nov 02, 2005 at 07:40:29AM +0000, John Sidney-Woollett wrote:
> If you have suffered data loss for this reason, then you'll need to get
> help from the developers to see whether it can be recovered, or what you
> can do to reconstruct the data.
The really nasty thing about it is that because the records are now
considered really old, as soon as you do run VACUUM it'll start
removing the rows you want to save...
What you need is a tool to go through and change any transaction ID
significantly in the future and freeze it... You know, like VACUUM...
Oh well..
In 8.1 autovacuum will make this kind of thing obsolete.
Have a nice day.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guido Neitzer | 2005-11-02 11:25:41 | Re: PostgreSQL, Mac OS X and locales |
| Previous Message | Martijn van Oosterhout | 2005-11-02 10:47:57 | Re: PostgreSQL, Mac OS X and locales |