On Monday, November 07, 2011 11:27:05 am Cody Caughlan wrote: > I am trying to restore a dump created with pg_dump, both source and > destination are Postgres 9.1.1 albeit different machines (source is Linux, > destination is OS X). > > $ pg_restore -U postgres -Fc -d batch_api_production > 2011110708_batch_api_production.dump.sql > pg_restore: [custom archiver] unexpected end of file > > pg_restore does seem like its doing something, as it doesnt error out until > 10-12 seconds in. > > I can dump the TOC just fine with pg_restore -l, which I've collected here: > > https://gist.github.com/951e417e7098fdf987d4 > > If I access the DB it appears that all the tables and sequences exist, but > none of the data or indexes & constraints. > > Any help would be appreciated. What do the database logs show when you do the restore? > > /Cody Caughlan -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
