Re: Large object corruption during 'piped' pg_restore

Hi Tom,

Tom Lane wrote:
> Bosco Rama <postgres(at)boscorama(dot)com> writes:
>> We've discovered (or possibly rediscovered?) a corruption when restoring large
>> objects.
>
>> If 'standard_conforming_strings = on' is set in our DB (which is required for
>> our app) then the piped restore method (e.g. pg_restore -O backup.dat | psql)
>> results in the large objects being corrupted.
>
> This vaguely reminds me of some long-since-fixed bug, but since you have
> neglected to give any version details, it's hard to say for sure.
> What PG version was the original server? The pg_dump you used to make
> the backup? The pg_restore? The target server?

Yeah, I only realized I hadn't added that as I saw it being sent. :-(

All servers and client tools involved are PG 8.4.6 on Ubuntu Server 10.04.1 LTS
with all current updates applied.

The dump file was made using: pg_dump -Fc -Z1 > backup.dat

Bosco.