=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb@xxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
