Skip site navigation (1) Skip section navigation (2)

Re: Backup to Tape Incomplete

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Backup to Tape Incomplete
Date: 2008-02-26 23:29:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
"Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au> writes:
> On Sun, Feb 24, 2008 at 9:20 PM, Phillip Smith
> <phillip(dot)smith(at)weatherbeeta(dot)com(dot)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

In response to


pgsql-admin by date

Next:From: Ivo RossacherDate: 2008-02-26 23:53:24
Subject: Re: encoding???
Previous:From: Phillip SmithDate: 2008-02-26 22:22:26
Subject: Re: Backup to Tape Incomplete

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group