On Wed, Apr 11, 2018 at 07:32:21PM -0700, Andres Freund wrote: > And there's cases where that just doesn't help at all. Being able to > untar a database from backup / archive / timetravel / whatnot, and then > fsyncing the directory tree to make sure it's actually safe, is really > not an insane idea. Or even just cp -r ing it, and then starting up a > copy of the database. What you're saying is that none of that is doable > in a safe way, unless you use special-case DIO using tooling for the > whole operation (or at least tools that fsync carefully without ever > closing a fd, which certainly isn't the case for cp et al). Does not seem like a problem to me, just checksum the thing if you really need to be extra safe. You should probably be doing it anyway if you backup / archive / timetravel / whatnot. -Lukas
