Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id EBE7D2E00E5 for ; Tue, 26 Feb 2008 19:31:52 -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 14701-02-9 for ; Tue, 26 Feb 2008 19:31:43 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id B89F62E014D for ; Tue, 26 Feb 2008 19:29:48 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m1QNTlGP009885; Tue, 26 Feb 2008 18:29:47 -0500 (EST) To: "Phillip Smith" cc: pgsql-admin@postgresql.org Subject: Re: Backup to Tape Incomplete In-reply-to: <011c01c878c6$114b89c0$9b0014ac@wbaus090> References: <011c01c878c6$114b89c0$9b0014ac@wbaus090> Comments: In-reply-to "Phillip Smith" message dated "Wed, 27 Feb 2008 09:22:26 +1100" Date: Tue, 26 Feb 2008 18:29:47 -0500 Message-ID: <9884.1204068587@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/349 X-Sequence-Number: 28423 "Phillip Smith" writes: > On Sun, Feb 24, 2008 at 9:20 PM, Phillip Smith > 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