Re: Backup to Tape Incomplete

"Phillip Smith" <phillip.smith@weatherbeeta.com.au> writes:
> On Sun, Feb 24, 2008 at 9:20 PM, Phillip Smith
> <phillip.smith@weatherbeeta.com.au> wrote:
>> A couple of possible things to try; pg_dump to a text file and try
> cat'ting that to the tape drive, or pipe it through tar and then to the
> tape.

> What would the correct syntax be for that - I can't figure out how to make
> tar accept stdin:

I don't think it can.  Instead, maybe dd with blocksize set equal to the
tape drive's required blocksize would do?  You'd have to check what
options your dd version has for padding out the last partial block.
Padding with spaces should work fine, not totally sure if nulls would
be OK.

            regards, tom lane