From: Scott Marlowe <scott.marlowe@gmail.com>
To: Phillip Smith <phillip.smith@weatherbeeta.com.au>
Cc: pgsql-admin@postgresql.org
Subject: Re: Backup to Tape Incomplete
Date: Mon, 25 Feb 2008 00:08:02 -0600
Message-ID: <dcc563d10802242208v34d47342yfc4baf07f240740a@mail.gmail.com> (raw)
In-Reply-To: <016d01c8775d$62382650$9b0014ac@wbaus090>
References: <016d01c8775d$62382650$9b0014ac@wbaus090>
On Sun, Feb 24, 2008 at 9:20 PM, Phillip Smith
<phillip.smith@weatherbeeta.com.au> 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.
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: scott.marlowe@gmail.com, phillip.smith@weatherbeeta.com.au
Subject: Re: Backup to Tape Incomplete
In-Reply-To: <dcc563d10802242208v34d47342yfc4baf07f240740a@mail.gmail.com>
* 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