can't restore database created with pg_dump

From: Eric Smith <eric_h_smith(at)me(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: can't restore database created with pg_dump
Date: 2014-09-20 02:51:34
Message-ID: 276A747A-63F0-4F95-90B0-AE2B43331C06@me.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-09-20 13:55:34 Re: can't restore database created with pg_dump
Previous Message Chris Travers 2014-09-20 02:42:37 Re: Why isn't Java support part of Postgresql core?