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@iol.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@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support