On 2/1/2011 3:44 PM, David Johnston wrote:
Hello, I have just done a multi-part migration and am having difficulty viewing binary content stored in a “bytea” field; specifically I stored a PDF in the existing setup and now receive a “File does not begin with ‘%PDF-‘” message when I go to pull it up from the new setup. The specific migration is as follows: Existing: Windows 2000 (32bit); PostgreSQL 8.2 New: Ubuntu 10.10 (64bit); PostgreSQL 9.0 To migrate the data I did the following: Pg_dump (v 8.3) from the existing Windows (32) Machine into a dump file on an NTFS file system. Pg_restore (v 9.0) from a different Windows (64) machine from the dump file into the running Linux (64) server. Using the same application software and JRE (Tomcat container) I attempted to view the files as normal (using Firefox on a Windows Machine) and the “File does not begin with ‘%PDF-‘” message appears. I can think of some possible variations and causes for this but figured before I go running for the cliff I’d see if anyone can at least point me in the right direction. Thank You David Johnston
Not sure if it'll help, but you could try the pg_dump from version 9 to do the backup.
-Andy -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
