Re: Issues with imported blobs from Postgres 8 to 9 - Mailing list pgsql-general

From Mahdi Mankai
Subject Re: Issues with imported blobs from Postgres 8 to 9
Date
Msg-id 484D04F9-692C-4237-8470-CD743F60B418@fuegoondemand.com
Whole thread Raw
In response to Re: Issues with imported blobs from Postgres 8 to 9  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Issues with imported blobs from Postgres 8 to 9  ("David Johnston" <polobo@yahoo.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Gary Fu
Date:
Subject: Re: slow building index and reference after Sybase to Pg
Next
From: "David Johnston"
Date:
Subject: Re: Issues with imported blobs from Postgres 8 to 9