there is a wiki page aouble corruption detection： http://wiki.postgresql.org/index.php?title=Corruption_detection
but I think avoid corruption is more important and practical than try to check corruption： http://blog.ringerc.id.au/2012/10/avoiding-postgresql-database-corruption.html Jov blog: http:amutu.com/blog <http://amutu.com/blog> 2013/5/28 Nikhil G Daddikar <n...@celoxis.com> > Folks, > > I was using PostgreSQL 8.x in development environment when one day I > started getting all kinds of low-level errors while running queries and > eventually had to reinstall. Maybe it was salvageable but since it was a > test database anyway it didn't matter. > > We use PostgreSQL 9 on our production server and I was wondering if there > there is a way to know when pages get corrupted. I see that there is some > kind of checksum maintained from 9.3 but till then is there a way to be > notified quickly when such a thing happens? I use a basebackup+rsync of WAL > files as a disaster recovery solution. Will this be useful when such a > scenario occurs? > > Thanks. > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general> > >
