Re: BUG #5925: Files corrupted

Excerpts from Castro's message of vie mar 11 09:06:00 -0300 2011:
>
> The following bug has been logged online:
>
> Bug reference: 5925
> Logged by: Castro
> Email address: flashed(at)iol(dot)pt
> PostgreSQL version: 9.0
> Operating system: Windows Server 2003
> Description: Files corrupted
> Details:
>
> I change Postgresql v8.4 to v9. Before that i bakup all databases. After
> Postgresql v9 installed i restore the backup. One of the database has a
> table that contains files(pdf, png, etc...).
>
> When i tryed to open this files, the windows give me a error "File
> corrupt".
>
> Can u help with this error, why the change of postgresql to version 9
> corrupted the files?

I think you're being bitten by the bytea_output change. Try setting
that to "escape" in postgresql.conf. If that works, look it up in the
manual so that you can figure out what's the best long-term solution.

--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support