Обсуждение: Migrating from 32 to 64 bit

Hi,

I'm currently setting up 2 new servers to act as a PgSQL cluster (8.2).

This basically consists in the reinstallation of the OS (64Bit).

Question:
I'd like to know if it is possible (and wise) to just keep the
/var/lib/postgres...... directories from the old 32Bit server to use on
the 64Bit version.

This is just as a personal interest since I can also just dump and
restore the database in about 2.5 hrs.

Thanks

Laurent

Douglas McNaught wrote:
> Nope, not possible--different architectures result in different data layouts.
>
> Dump & restore is the way to go.
>

Thanks,

I'll then dump/restore.

Laurent

On Nov 24, 2007, at 6:18 PM, Laurent CARON wrote:

> Question:
> I'd like to know if it is possible (and wise) to just keep the
> /var/lib/postgres...... directories from the old 32Bit server to use
> on
> the 64Bit version.
>
> This is just as a personal interest since I can also just dump and
> restore the database in about 2.5 hrs.

No, you must dump/reload.