Thread: BUG #5925: Files corrupted

BUG #5925: Files corrupted

From
"Castro"
Date:
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?

Re: BUG #5925: Files corrupted

From
Alvaro Herrera
Date:
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