[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 12:04:07 +0200 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
On Fri, May 31, 2013 at 09:45:42AM +0000, Jim Busser wrote:
> >> 3) we cannot simply use pg_dumpall and throw away the result
> >> because we need not have sufficient priviledges
> >
> > However, if our backup can complete successfully that means
> > there does not seem to be corruption of data and indices at
> > the file system and PG file structure levels (no use at the
> > layout[=hash] or content[=nigh impossible] levels, though).
>
> Therefore, a combination of
>
> (1) the client connecting without complaint, and
>
> (2) setting up the backup, and determining that it completes successfully and
>
> (3) ideally, restoring from a backup onto a different machine and confirming
> that a client will run
>
> provide a good measure, and
>
> even (1) and (2) without 3 provide modest reassurance … ?
Indeed. Semantic (non-file-structure) content corruption
is still possible.
Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
- Re: [Gnumed-devel] Corrupt database, (continued)
- 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, 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 <=
- 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