Postgres Pro
Downloads
Home   >   mailing lists

Thread: Question about data corruption issue of 9.1 (pre 9.1.6)

Question about data corruption issue of 9.1 (pre 9.1.6)

From
Denis Gasparin
Date:

Hi to all.

We have a 9.1.5 production database that never crashed and today we upgraded it to 9.1.6.

The question: do we need to follow the vacuum/reindex procedure (as specified here http://wiki.postgresql.org/wiki/20120924updaterelease) even if the database never crashed?

Thank you in advance

Denis Gasparin
---
Edistar SRL

Re: Question about data corruption issue of 9.1 (pre 9.1.6)

From
Craig Ringer
Date:
On 11/06/2012 03:00 PM, Denis Gasparin wrote:
p { margin: 0; }

Hi to all.

We have a 9.1.5 production database that never crashed and today we upgraded it to 9.1.6.

The question: do we need to follow the vacuum/reindex procedure (as specified here http://wiki.postgresql.org/wiki/20120924updaterelease) even if the database never crashed?
Based on the wiki, I'd say the answer is "no" if your DB was never shut down for any of the listed causes.

It's pretty clear that if it always flushed buffers cleanly then it'll be fine.

--
Craig Ringer