Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about data corruption issue of 9.1 (pre 9.1.6) - Mailing list pgsql-general

From Craig Ringer
Subject Re: Question about data corruption issue of 9.1 (pre 9.1.6)
Date
Msg-id 5098C18D.9050202@ringerc.id.au
Whole thread Raw
In response to Question about data corruption issue of 9.1 (pre 9.1.6)  (Denis Gasparin <denis@edistar.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Tianyin Xu
Date:
Subject: Does PostgreSQL have complete functional test cases?
Next
From: Pavel Stehule
Date:
Subject: Re: Does PostgreSQL have complete functional test cases?