pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Phillip Smith <phillip.smith@weatherbeeta.com.au>
Cc: pgsql-admin@postgresql.org
Subject: Re: Backup to Tape Incomplete
Date: Tue, 26 Feb 2008 18:29:47 -0500
Message-ID: <9884.1204068587@sss.pgh.pa.us> (raw)
In-Reply-To: <011c01c878c6$114b89c0$9b0014ac@wbaus090>
References: <011c01c878c6$114b89c0$9b0014ac@wbaus090>

"Phillip Smith" <phillip.smith@weatherbeeta.com.au> writes:
> On Sun, Feb 24, 2008 at 9:20 PM, Phillip Smith
> <phillip.smith@weatherbeeta.com.au> 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



view thread (15+ messages)  latest in thread

Message-ID: <9884.1204068587@sss.pgh.pa.us>
Permalink:  ../9884.1204068587@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/9884.1204068587@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, phillip.smith@weatherbeeta.com.au
  Subject: Re: Backup to Tape Incomplete
  In-Reply-To: <9884.1204068587@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox