On Sun, Feb 24, 2008 at 9:20 PM, Phillip Smith <phillip.smith@xxxxxxxxxxxxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
