Re: dump/restore needed when switching from 32bit to 64bit processor architecture?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dirk Lutzebäck <lutzeb(at)aeccom(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: dump/restore needed when switching from 32bit to 64bit processor architecture?
Date: 2005-07-19 14:05:43
Message-ID: 23511.1121781943@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb(at)aeccom(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-07-19 14:17:35 Re: Old question - failed to find conversion function from "unknown"
Previous Message Shashi Kanth Boddula 2005-07-19 13:32:06 Mirroring problem with PostgreSQL

Browse pgsql-general by date

  From Date Subject
Next Message Alex Stapleton 2005-07-19 14:06:47 Stored Procedures for Security
Previous Message David Parker 2005-07-19 13:51:50 pg_dump and write locks