Re: Issues with imported blobs from Postgres 8 to 9

Thanks for the reply.

What kind of detail can I provide?

Mahdi

On 2011-02-28, at 6:58 PM, Tom Lane wrote:

> Mahdi Mankai <mahdi.mankai@fuegoondemand.com> writes:
>> I created a database dumb using pg_dump on Postgres 8.3.6. After that I tried to import the same database into a
Postgres9.0 install. Everything worked fine except some image blobs. Some of them seem to be corrupt. 
>
> I doubt this is a bytea_escape problem.  In the first place that would
> only affect output from the new server, not input into it; and in the
> second place, if that were the issue, it would probably result in *all*
> your blobs being messed up not just a small number of them.  We need
> a lot more details than this to offer any help.
>
>             regards, tom lane
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general