Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A34AB2E0052 for ; Tue, 26 Feb 2008 21:09:28 -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 12866-02 for ; Tue, 26 Feb 2008 21:09:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mout.perfora.net (mout.perfora.net [74.208.4.197]) by postgresql.org (Postfix) with ESMTP id AB7182E004C for ; Tue, 26 Feb 2008 21:09:25 -0400 (AST) Received: from [172.16.255.106] (66-23-211-34.clients.speedfactory.net [66.23.211.34]) by mrelay.perfora.net (node=mrus1) with ESMTP (Nemesis) id 0MKpCa-1JUAnP1IWI-0007I8; Tue, 26 Feb 2008 20:09:23 -0500 Message-ID: <47C4B83E.4060408@serioustechnology.com> Date: Tue, 26 Feb 2008 20:09:18 -0500 From: Geoffrey User-Agent: Thunderbird 1.5.0.8 (X11/20061025) MIME-Version: 1.0 To: Tom Lane CC: Phillip Smith , pgsql-admin@postgresql.org Subject: Re: Backup to Tape Incomplete References: <011c01c878c6$114b89c0$9b0014ac@wbaus090> <9884.1204068587@sss.pgh.pa.us> In-Reply-To: <9884.1204068587@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V01U2FsdGVkX19ZwarDGTSgQHIF1ngF/MXtEb3IbSZdD6MTTSJ 47nLAlVw2nzvpyEu3sqrsqq2z047Fn318aiUU86DdGkoaz/j6N KW0zsa0L22o6e3D2f4yI8sed38hWXcV X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/351 X-Sequence-Number: 28425 Tom Lane wrote: > "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. Coming in the middle of this thread, so slap me if I'm off base here. tar will accept standard in as: tar -cf - the '-f -' says take input. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin