Re: Data loss, vacuum, transaction wrap-around - Mailing list pgsql-hackers

From pgsql@mohawksoft.com
Subject Re: Data loss, vacuum, transaction wrap-around
Date
Msg-id 16635.24.91.171.78.1108854282.squirrel@mail.mohawksoft.com
Whole thread Raw
In response to Re: Data loss, vacuum, transaction wrap-around  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: Data loss, vacuum, transaction wrap-around
List pgsql-hackers
> On Sat, Feb 19, 2005 at 13:35:25 -0500,
>   lsunley@mb.sympatico.ca wrote:
>>
>> The catastrophic failure of the database because a maintenence function
>> is
>> not performed is a problem with the software, not with the people using
>> it.
>
> There doesn't seem to be disagreement that something should be done going
> forward.
>
> The disagreement sems to be what effort should be made in back porting
> fixes to previous versions.


Now, lets imagine PostgreSQL is being developed by a large company. QA
announces it has found a bug that will cause all the users data to
disappear if they don't run a maintenence program correctly. Vacuuming one
or two tables is not enough, you have to vacuum all tables in all
databases.

This bug would get marked as a critical error and a full scale effort
would be made to contact previous users to upgrade or check their
procedures.




pgsql-hackers by date:

Previous
From: pgsql@mohawksoft.com
Date:
Subject: Re: Data loss, vacuum, transaction wrap-around
Next
From: Andrew Dunstan
Date:
Subject: Re: Data loss, vacuum, transaction wrap-around