Re: Data loss, vacuum, transaction wrap-around

From: Mark Kirkwood <markir(at)coretech(dot)co(dot)nz>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: pgsql(at)mohawksoft(dot)com, Jaime Casanova <systemguards(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Russell Smith <mr-russ(at)pws(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Data loss, vacuum, transaction wrap-around
Date: 2005-02-20 01:41:35
Message-ID: 4217EACF.4010207@coretech.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andrew Dunstan wrote:

> There is no news in the problem you're complaining of. It's completely
> known and documented. You've stated before that you've been using
> PostgreSQL for years - why is this suddenly so urgent that we have to
> drop everything and backpatch old releases? Please move along, there's
> nothing to see here, these are not the bugs you've been looking for.

To be fair to Mark, there does seem to be an increasing number of
reports of this issue. In spite of the in-the-works fix for 8.1, it
would be a pity to see customers losing data from xid wrap-around.

However the quandary is this : even if we did back patches for every
version, said customers probably wouldn't know they needed to apply them
- hmmm, not much help there. We might be better off merely announcing
the need to use vacuumdb on www.postgresql.org!

regards

Mark (the other one)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Bierman 2005-02-20 02:43:14 Fwd: Apple Darwin disabled fsync?
Previous Message Andrew Dunstan 2005-02-19 23:17:55 Re: Data loss, vacuum, transaction wrap-around