pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedunable to restore
2+ messages / 2 participants
[nested] [flat]
* unable to restore
@ 2008-08-26 20:11 Ken.Colson@sage.com
0 siblings, 1 reply; 2+ messages in thread
From: Ken.Colson@sage.com @ 2008-08-26 20:11 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: unable to restore
@ 2008-08-26 21:26 Scott Marlowe <scott.marlowe@gmail.com>
parent: Ken.Colson@sage.com
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2008-08-26 21:26 UTC (permalink / raw)
To: Ken.Colson@sage.com; +Cc: pgsql-admin
On Tue, Aug 26, 2008 at 2:11 PM, <Ken.Colson@sage.com> wrote:
> 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"
>
Make sure that your dump is actually completing. We had a dump that
was failing due to a statement timeout making the copy command in the
dump fail and got a similar error.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-08-26 21:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-08-26 20:11 unable to restore Ken.Colson@sage.com
2008-08-26 21:26 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox