Re: Enabling Checksums
Ken Marshall <ktm@rice.edu>
From: "ktm@rice.edu" <ktm@rice.edu>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Heikki Linnakangas <hlinnakangas@vmware.com>, Simon Riggs <simon@2ndQuadrant.com>, Greg Smith <greg@2ndquadrant.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2013-03-04T21:18:17Z
Lists: pgsql-hackers
On Mon, Mar 04, 2013 at 01:00:09PM -0800, Jeff Davis wrote: > On Mon, 2013-03-04 at 22:27 +0200, Heikki Linnakangas wrote: > > If you're serious enough about your data that you want checksums, you > > should be able to choose your filesystem. > > I simply disagree. I am targeting my feature at casual users. They may > not have a lot of data or a dedicated DBA, but the data they do have > might be very important transactional data. > > And right now, if they take a backup of their data, it will contain all > of the corruption from the original. And since corruption is silent > today, then they would probably think the backup is fine, and may delete > the previous good backups. > +1 There is no reasonable availability of checksum capable filesystems across PostgreSQL's supported OSes. It really needs to be available in core. Regards, Ken