Re: [Gnumed-devel] Corrupt database

[Karsten Hilbert]

On Fri, May 31, 2013 at 08:06:57AM +0000, Jim Busser 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?

1) our backup script already does

2) we don't use pg_dumpall except to dump roles which isn't
   sufficient to fulfill Tom's preconditions

3) we cannot simply use pg_dumpall and throw away the result
   because we need not have sufficient priviledges

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346