[TriLUG] Using gzip to backup postgres to tape

[Andrew Perrin]

pg_dump actually produces tar output (that's the -F t option).

ap

----------------------------------------------------------------------
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:
>
>> /usr/bin/pg_dump -F t leted | /bin/gzip -c > /dev/nst0
>
> assuming pg_dump is just producing a stream, how about
>
> /usr/bin/pg_dump -F t leted | /bin/gzip -c | 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/
>