Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group