can't restore database created with pg_dump

Поиск
Список
Период
Сортировка
От Eric Smith
Тема can't restore database created with pg_dump
Дата
Msg-id 276A747A-63F0-4F95-90B0-AE2B43331C06@me.com
обсуждение исходный текст
Ответы Re: can't restore database created with pg_dump  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: Chris Travers
Дата:
Сообщение: Re: Why isn't Java support part of Postgresql core?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: can't restore database created with pg_dump