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 just created 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
