Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 073662E00E7 for ; Mon, 25 Feb 2008 02:08:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 37879-08 for ; Mon, 25 Feb 2008 02:08:03 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.235]) by postgresql.org (Postfix) with ESMTP id E01192E0033 for ; Mon, 25 Feb 2008 02:08:04 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id 71so2317319wri.5 for ; Sun, 24 Feb 2008 22:08:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=D+uZZCFSx4XyqML42oGV5sVvlevoincVXf+XFzsrJi4=; b=pZKlsMmT1KgCOpa1SHuENgfIVtLmyZE2A2bAjw7JQIilj++tMg2bUynkJ9Uw/4d2Bbs0gN5FgRRIw6Fl1m9Wz1069qlRjZDcfh3QmSqTDVaTr57YEVv4SEvu4IFI+EZTSULZ9PIzEQIvi7gcWkiTQLCZfd8BjQsH0430M+4BMmw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=b8y9N6HHR0F5NNIh7rT1qfm6HeEsTelUJ5aJLpNVA9xCDkETPcrEdwfQUl1iQgD8R/Nf7yCKaKfH4MaTrkJy/K3IjHD+cH+VqjFGoeUt29tE3w3tqJ/1awEsN25Z97KYiQ0ccU5kdipUr+QRO7iLVPlRWeahPkgz9EdttYYNSTI= Received: by 10.115.49.16 with SMTP id b16mr3002728wak.65.1203919682369; Sun, 24 Feb 2008 22:08:02 -0800 (PST) Received: by 10.114.133.6 with HTTP; Sun, 24 Feb 2008 22:08:02 -0800 (PST) Message-ID: Date: Mon, 25 Feb 2008 00:08:02 -0600 From: "Scott Marlowe" To: "Phillip Smith" Subject: Re: Backup to Tape Incomplete Cc: pgsql-admin@postgresql.org In-Reply-To: <016d01c8775d$62382650$9b0014ac@wbaus090> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <016d01c8775d$62382650$9b0014ac@wbaus090> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/310 X-Sequence-Number: 28384 On Sun, Feb 24, 2008 at 9:20 PM, Phillip Smith wrote: > PostgreSQL 8.2.4 > RedHat ES4 > > I have a nightly cron job that is (supposed) to dump a specific database to > magnetic tape: > /usr/local/bin/pg_dump dbname > /dev/st0 > > This runs, and doesn't throw any errors, but when I try to restore it fails > because the tape is incomplete: 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.