Re: [Gnumed-devel] Corrupt database

[Busser, Jim]

On 2013-05-31, at 12:37 AM, Jim Busser <address@hidden> wrote:

> exists there any postgres maintenance function or utility that can test and 
> report the integrity or non-integrity of the database?


No … at least, nothing internal to pg that is automatic. Some links below.

Tom Lane suggests failure of completion of pg_dumpall to be an important sign 
of a problem.

Is there some way for the backup script to notify a user when there was a 
failure of completion of pg_dumpall?

Links:

        http://www.postgresql.org/message-id/address@hidden

        
http://dba.stackexchange.com/questions/10533/postgresql-database-data-file-integrity-check

        http://forums.devshed.com/showpost.php?p=2864325&postcount=8

        http://osdir.com/ml/db.postgresql.admin/2002-11/msg00080.html

        pg_check
        http://www.fuzzy.cz/en/articles/checking-integrity-using-pg-check/

        pgcheck
        http://pgfoundry.org/projects/pgcheck

-- JIm