Postgres Pro
Downloads
Home   >   mailing lists

Re: dump/restore needed when switching from 32bit to 64bit processor architecture? - Mailing list pgsql-admin

From Tom Lane
Subject Re: dump/restore needed when switching from 32bit to 64bit processor architecture?
Date
Msg-id 23511.1121781943@sss.pgh.pa.us
Whole thread Raw
In response to dump/restore needed when switching from 32bit to 64bit processor architecture?  (Dirk Lutzebäck <lutzeb@aeccom.com>)
Responses Re: dump/restore needed when switching from 32bit to 64bit  (Dirk Lutzebäck <lutzeb@aeccom.com>)
List pgsql-admin
Tree view 
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb@aeccom.com> writes:
> when have a 8.0.3 database running on a XEON machine. We want to replace
> it with an Opteron where postgresql is to be compiled with 64bit. Do we
> need a dump/restore or can we just start the db with the new compilation?

I'd bet you need a dump/restore --- MAXALIGN is most likely different
on the two platforms.  If it isn't, then maybe you could get away with
this, but it's definitely risky.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Martin Fandel"
Date:
Subject: Re: backing up without lock ?
Next
From: "guly"
Date:
Subject: how to build vsftpd with pgsql pam