Re: 32-bit to 64-bit migration screwup

On 10/26/07, Devrim GÜNDÜZ <devrim(at)commandprompt(dot)com> wrote:
> Hi,
>
> On Thu, 2007-10-25 at 22:52 -0700, David Young wrote:
> > FATAL: incorrect checksum in control file
>
> Did you move the old data files to the new server? If so, it won't work.
> Dump your 32-bit database with 32-bit binaries, and load that data to
> your 64-bit database.

Not necessarily-- you can run old, 32bit environment under 64bit kernel
(if you enabled 32-bit compatibility in kernel). Just run your old environment
in chroot.

I have recently did such a migration (old 32bit system in chroot, pg_dump,
pipe to psql on new system).

Regards,
Dawid