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: flas...@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 <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
