[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Corrupt database
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] Corrupt database |
Date: |
Fri, 31 May 2013 10:52:58 +0200 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
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
- [Gnumed-devel] Corrupt database, Vaibhav Banait, 2013/05/30
- Re: [Gnumed-devel] Corrupt database, Jerzy Luszawski, 2013/05/30
- Re: [Gnumed-devel] Corrupt database, Karsten Hilbert, 2013/05/30
- Re: [Gnumed-devel] Corrupt database, Busser, Jim, 2013/05/30
- Re: [Gnumed-devel] Corrupt database, Busser, Jim, 2013/05/31
- Re: [Gnumed-devel] Corrupt database, Karsten Hilbert, 2013/05/31
- Re: [Gnumed-devel] Corrupt database, Busser, Jim, 2013/05/31
- Re: [Gnumed-devel] Corrupt database, Busser, Jim, 2013/05/31
- Re: [Gnumed-devel] Corrupt database,
Karsten Hilbert <=
- Re: [Gnumed-devel] Corrupt database, Karsten Hilbert, 2013/05/31
- Re: [Gnumed-devel] Corrupt database, Busser, Jim, 2013/05/31
- Re: [Gnumed-devel] Corrupt database, Karsten Hilbert, 2013/05/31
- Re: [Gnumed-devel] Corrupt database, Busser, Jim, 2013/05/31
- Re: [Gnumed-devel] Corrupt database, Karsten Hilbert, 2013/05/31
- Re: [Gnumed-devel] Corrupt database, Karsten Hilbert, 2013/05/31
- Re: [Gnumed-devel] Corrupt database, Jerzy Luszawski, 2013/05/31