support quality (Re: dump | restore fails: unknown tape headertype 1853384566)

[Karl Denninger]

Peter Schuller wrote:
>> To add to this what SHOULD (ha!) work is to dump the database partition 
>> FIRST and THEN dump the Transaction Log partition.
>>     
>
> Depending on how the database works; specifically when old data in the
> log may or may not be expunged. You could do this with PostgreSQL by
> using it's PITR support for example. But to the extent that you have a
> log which is only supposed to be used for internal reasons (such as
> with pg by default), you'd likely be in trouble anyway unless you had
> a specific reason to know that it is safe.
>   
True.  If the log rolls on you while you're taking the dumps you're DEAD.

Both design and verification are important :)

-- 
--
Karl Denninger
karl at denninger.net