On Thu, Feb 01, 2018 at 02:24:46PM +0100, Michael Banck wrote:
> dumping a database to /dev/null via pg_dump is (AFAIK) one recommended
> way to check for corruption. However, dumping to /dev/null is currently
> not supported in directory mode which makes it not possible to dump to
> /dev/null in parallel.
FWIW, I use this trick as well in some test deployments. Now, those
deployments happen in places where I want the checks to warn me, so the
time it takes is not really an issue generally. Do folks here think
that speedups would be worth it? Say to make the operation shorter on
production systems for example. A lengthy pg_dump bloats data for a
longer time, so I can buy that shorter times may help, though I think
that hearing from other folks is necessary as well.
--
Michael