pgsql and MAXALIGN

nordic bro · Guru Joined: 25 Oct 2003 Posts: 585

not really sure where this should go but I have a pgsql "data" dir from a mac I'm trying to get working on my amd64 linux. I compiled the pgsql version that "data" came from and when I try to start it I get a fatal err:

The database cluster was initialized with MAXALIGN 0, but the server was compiled with MAXALIGN 8.

not being able to find much on that I tried recompiling w/CC="gcc -m32 --target=i386 ..." to see what would happen and got this next:

... but the server was compiled with MAXALIGN 4.

presumably a "MAXALIGN 0" means it was unset when the mac bins were built, maybe because mac arch doesn't support MAXALIGN or something? is there a way around this such that I can build the linux pgsql bins to get a MAXALIGN 0 too?

when I check compile env I see these so could changing to something else be what I need to do? if so what would I change them too? or do they not matter?

HOSTTYPE=x86_64-linux
MACHTYPE=x86_64

thanks.

mike155 · Posted: Fri Jul 26, 2013 6:28 pm Post subject:

nordic bro · Guru Joined: 25 Oct 2003 Posts: 585

thanks but tbh all I'm interested in is what I posted about, whether or not I can do anything about MAXALIGN when compiling. what is/is not supported isn't a concern although of course I'd be interested to know that one has first-hand knowledge going from mac to another platform is functionally impossible.

if I can get it running in order to dump text data from a table for a customer that's what I'm after. I've never had probs I can't deal with when moving/recovering "data" between win machines, this is the first time I've tried to do so for a mac (intel mac if it matters).

titanofold · Posted: Tue Jul 30, 2013 2:48 am Post subject:

No, you can't adjust MAXALIGN. It's particular to the OS and system.

The best process is a dump and restore.
_________________
The best things in life are free.
Guy-1: Surely, you will fold with me...
Guy-2: Alright, but don't call me Shirley