Re: Large object corruption during 'piped' pg_restore

Hi Tom,

Tom Lane wrote:
> Bosco Rama <postgres@boscorama.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.