can't restore database created with pg_dump - Mailing list pgsql-general

From Eric Smith
Subject can't restore database created with pg_dump
Date
Msg-id 276A747A-63F0-4F95-90B0-AE2B43331C06@me.com
Whole thread Raw
Responses Re: can't restore database created with pg_dump
List pgsql-general
All,

I created a backup using pg_dump, postgres 8.3.  I'm trying to restore that into a new postgres 9.3.5 installation.  I
justcreated the default text format output with pg_dump, and am trying to restore using psql < dumpfile. 

I have images saved as bytea, and I get the following error when trying to restore:

ERROR: invalid input syntax for type bytea.
CONTEXT:  COPY images, line 8, column imageData:
"MM\000*\003':\242\200?\300\0208$\026\015\007\204BaP\270d6\035\017\210Da\317\307\350\030\000\001\177\..."


On some of my installations the restore process works, and on some it fails.  All installations are moving from 8.3 to
9.3.5. Any ideas? 

Thanks,
Eric



pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: Why isn't Java support part of Postgresql core?
Next
From: Adrian Klaver
Date:
Subject: Re: can't restore database created with pg_dump