64bit build vs 32 bit build

Started by Dave Cramerover 19 years ago3 messages
#1Dave Cramer
pg@fastcrypt.com

Is it possible to use a binary copy of the cluster on a 64 bit build
of pg 7.4.x that was created on a 32bit bild of 7.4.x

assuming x is the same and integer-date-times are not enabled ?

Dave

#2Martijn van Oosterhout
kleptog@svana.org
In reply to: Dave Cramer (#1)
Re: 64bit build vs 32 bit build

On Tue, May 30, 2006 at 08:50:23AM -0400, Dave Cramer wrote:

Is it possible to use a binary copy of the cluster on a 64 bit build
of pg 7.4.x that was created on a 32bit bild of 7.4.x

assuming x is the same and integer-date-times are not enabled ?

I doubt it very much. Or put another way, no effort has been put into
making it work...

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

Show quoted text

From each according to his ability. To each according to his ability to litigate.

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Martijn van Oosterhout (#2)
Re: 64bit build vs 32 bit build

Martijn van Oosterhout <kleptog@svana.org> writes:

On Tue, May 30, 2006 at 08:50:23AM -0400, Dave Cramer wrote:

Is it possible to use a binary copy of the cluster on a 64 bit build
of pg 7.4.x that was created on a 32bit bild of 7.4.x

I doubt it very much. Or put another way, no effort has been put into
making it work...

Even more to the point: the reason it won't work is that MAXALIGN is
probably different in the two builds. Very recent PG releases check
this via a pg_control field, but 7.4.x will probably just crash.

regards, tom lane