From: | Ken(dot)Colson(at)sage(dot)com |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | unable to restore |
Date: | 2008-08-26 20:11:38 |
Message-ID: | 057BEBE753E8AD4D8F202B35578D8169090BFB96@gnvalex004-backup.mmrd.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Greetings,
I am running pg_dump 8.2.5 and attempting to restore with a pg_restore 8.2.4
on a test machine and the restore errors out with this error:
pg_restore: [custom archiver] could not read from input file: end of file
pg_restore: *** aborted because of error
ERROR: missing data for column "appversion"
Here is the dump command that we use:
pg_dump -b -Fc dbname -f filename.restore
Here is the restore command that I am using:
cat filename.restore|pg_restore -v -t tablename|psql -U postgres dbname
I have tried different dumps from different days but it croaks on the same
table , with the same error. Querying this data from the DB looks fine to
me and there are no other symptoms of possible corruption (that I know of)
This is a process that has been working for years, nothing new has been
introduced since I was able to successfully do this about 2-3 weeks ago,
except for data.
Any help appreciated, thanks,
Ken
From | Date | Subject | |
---|---|---|---|
Next Message | Napolean Periathambi | 2008-08-26 20:35:30 | registry permissions |
Previous Message | Jeff Frost | 2008-08-26 19:32:39 | Re: vacuum verbose relations reporting |