unable to restore - Mailing list pgsql-admin

From Ken.Colson@sage.com
Subject unable to restore
Date
Msg-id 057BEBE753E8AD4D8F202B35578D8169090BFB96@gnvalex004-backup.mmrd.com
Whole thread Raw
Responses Re: unable to restore  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List 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 by date:

Previous
From: Jeff Frost
Date:
Subject: Re: vacuum verbose relations reporting
Next
From: Napolean Periathambi
Date:
Subject: registry permissions