Home > Archive > PostgreSQL Discussion > May 2005 > Portability of pgsql database files.









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Portability of pgsql database files.
David M. Lee

2005-05-26, 1:23 pm

I have a system that is dual bootable for both i686 and x86_64. Would
there be any issues using the PostgreSQL database files generated for
i686 on x86_64, or vice versa?

Thanks!
dave
<><

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Bruce Momjian

2005-05-26, 1:23 pm

David M. Lee wrote:
> I have a system that is dual bootable for both i686 and x86_64. Would
> there be any issues using the PostgreSQL database files generated for
> i686 on x86_64, or vice versa?


Uh, if the padding is the same, it would work, but we never test such
things.

--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Tom Lane

2005-05-26, 1:23 pm

"David M. Lee" <dmlee@Crossroads.com> writes:
> I have a system that is dual bootable for both i686 and x86_64. Would
> there be any issues using the PostgreSQL database files generated for
> i686 on x86_64, or vice versa?


You'd probably have problems with the different data alignment rules for
the two architectures (I'm supposing MAXALIGN is different, though
perhaps it is not?).

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com