[TriLUG] Using gzip to backup postgres to tape

Andrew Perrin clists at perrin.socsci.unc.edu
Mon Nov 27 13:55:37 EST 2006


Thanks, but gzip actually handles tar format fine; sending the same output 
to a file instead of tape works without problem.

To confirm that it's about writing to the tape, I tried this:

cat 2006-02-21.backup.log  | /bin/gzip -c > /dev/nst0

gzip: stdout: Invalid argument




which shows that something about gzip's output makes the tape drive choke.

Andy

----------------------------------------------------------------------
Andrew J Perrin - andrew_perrin (at) unc.edu - http://perrin.socsci.unc.edu
Assistant Professor of Sociology; Book Review Editor, _Social Forces_
University of North Carolina - CB#3210, Chapel Hill, NC 27599-3210 USA
New Book: http://www.press.uchicago.edu/cgi-bin/hfs.cgi/00/178592.ctl



On Mon, 27 Nov 2006, Joseph Mack NA3T wrote:

> On Mon, 27 Nov 2006, Andrew Perrin wrote:
>
>> pg_dump actually produces tar output (that's the -F t option).
>
> OK. (Just guessing) gzip may not handle tar format. Can you leave off the -F 
> t ?
>
> what about
>
> /usr/bin/pg_dump leted | tar -czf /dev/nst0 -
>
> Joe
>
> -- 
> Joseph Mack NA3T EME(B,D), FM05lw North Carolina
> jmack (at) wm7d (dot) net - azimuthal equidistant map
> generator at http://www.wm7d.net/azproj.shtml
> Homepage http://www.austintek.com/ It's GNU/Linux!
> -- 
> TriLUG mailing list        : http://www.trilug.org/mailman/listinfo/trilug
> TriLUG Organizational FAQ  : http://trilug.org/faq/
> TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
>



More information about the TriLUG mailing list