unable to restore
От | Ken.Colson@sage.com |
---|---|
Тема | unable to restore |
Дата | |
Msg-id | 057BEBE753E8AD4D8F202B35578D8169090BFB96@gnvalex004-backup.mmrd.com обсуждение исходный текст |
Ответы |
Re: unable to restore
|
Список | 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
В списке pgsql-admin по дате отправления: