gnumed-devel
[Top][All Lists]
Advanced

[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



reply via email to

[Prev in Thread] Current Thread [Next in Thread]