[TriLUG] Using gzip to backup postgres to tape

[Len Boyle]

Andrew, 

Try to remove the last "-" and see if that works. So ....| tar -czf /dev/nst0'

Or ....| tar -czf - | dd -of /dev/nst0  

You might have to spec a blocksize on tar and then the same blocksize on dd to have good performance. 
If you have a newer tape drive then something like 256KB.  

-----Original Message-----
From: trilug-bounces at trilug.org [mailto:trilug-bounces at trilug.org] On Behalf Of Andrew Perrin
Sent: Monday, November 27, 2006 2:45 PM
To: Triangle Linux Users Group discussion list
Subject: Re: [TriLUG] Using gzip to backup postgres to tape

perrin:~# su postgres -c '/usr/bin/pg_dump leted | tar -czf /dev/nst0 -'
tar: -: Cannot stat: No such file or directory
tar: Error exit delayed from previous errors


----------------------------------------------------------------------
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:
>
>> Thanks, but gzip actually handles tar format fine;
>
> yes of course (doh).
>
> o gzip handles tar format
>
> o the tape drive wants tar format.
>
> I don't have a tape drive to test this on, so I hope I'm not wasting your 
> time, but you didn't tell me what happened with
>
>>> /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/
>
-- 
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/