From: | Andy Colson <andy(at)squeakycode(dot)net> |
---|---|
To: | David Johnston <polobo(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Windows to Linux PostgreSQL Migration |
Date: | 2011-02-01 21:59:02 |
Message-ID: | 4D488226.802@squeakycode.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David Johnston | 2011-02-01 22:04:31 | Re: Windows to Linux PostgreSQL Migration |
Previous Message | David Johnston | 2011-02-01 21:44:51 | Windows to Linux PostgreSQL Migration |