Migration of /data from 32bit to 8.2 64bit

Lists: pgsql-general
From: Jean-Samuel Reynaud <reynaud(at)elma(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Migration of /data from 32bit to 8.2 64bit
Date: 2008-02-07 10:26:27
Message-ID: 20080207112627.65ddc8eb@jsr.elma.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Hi All,

I want to migration an existing database from a 32bit server to a 64bit
server. I will use exactly the same postgresql version (8.2.6).
Did I need to dump the data to do this or a single copy of /data will
work ?
Is any interger lenght impact on /data ?

Thanks,


From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Jean-Samuel Reynaud <reynaud(at)elma(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Migration of /data from 32bit to 8.2 64bit
Date: 2008-02-07 11:28:56
Message-ID: 20080207112856.GL12085@svr2.hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

On Thu, Feb 07, 2008 at 11:26:27AM +0100, Jean-Samuel Reynaud wrote:
> Hi All,
>
> I want to migration an existing database from a 32bit server to a 64bit
> server. I will use exactly the same postgresql version (8.2.6).
> Did I need to dump the data to do this or a single copy of /data will
> work ?
> Is any interger lenght impact on /data ?

You need to dump/reload.

//Magnus