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