[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Corrupt database
From: |
Busser, Jim |
Subject: |
Re: [Gnumed-devel] Corrupt database |
Date: |
Fri, 31 May 2013 08:06:57 +0000 |
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
- [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 <=
- 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, 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