Hello, I had a very nice system where I mirrored everything to another machine each night, so in case of disaster, I could easily switch over to the mirror.
The backup script uses a line like this: pg_dump -b -F t -h $postgresql_hostname $i > "$location_backup_dir/`date +%B-%Y`/$date_info/postgresql_database-$i-backup" I transfer the backup files by rsync and then run this on the mirror: pg_restore -c -U dbuser -d dbname -F t postgresql_database-db-backup This worked fine for months until I upgraded postgres on the main machine from 8.0.13 to 8.0.15. From then on I started getting these messages: pg_restore: [tar archiver] could not open TOC file for input: No such file or directory The funny thing is that this started when I upgraded postgres on the main main machine a little over a week ago, but I had already upgraded from 8.0.13 to 8.0.15 on the mirror machine back in January (and the error happens when I try to restore the backup on the mirror). If anyone can help, I would be very appreciative. -- Stuart Luppescu -=- slu .at. ccsr.uchicago.edu University of Chicago -=- CCSR 才文と智奈美の父 -=- Kernel 2.6.24-gentoo-r8 Is knowledge knowable? If not, how do we know that? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
