Thread: can be database files be copied using 'cp' between hosts with different endianess?

Hello,

I have a quesion - suppose I have sparc box and x86 box running same
release of postgresql compiled with same options. Can I simply copy database
directory between hosts (of course when postgresql server is stopped on both
boxes)?

BTW Mysql (MyISAM) and sqlite allow this.

Thanks for your answer in advance!
--
 Best regards,
  -Vlad

Vlad Harchev wrote:
> I have a quesion - suppose I have sparc box and x86 box running same
> release of postgresql compiled with same options. Can I simply copy
> database directory between hosts (of course when postgresql server is
> stopped on both boxes)?

Absolutely not.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

On Sat, Apr 09, 2005 at 08:42:19PM +0200, Peter Eisentraut wrote:
> Vlad Harchev wrote:
> > I have a quesion - suppose I have sparc box and x86 box running same
> > release of postgresql compiled with same options. Can I simply copy
> > database directory between hosts (of course when postgresql server is
> > stopped on both boxes)?
>
> Absolutely not.

That's a pity..
Thanks for your answer!

--
 Best regards,
  -Vlad

I've been able to do Solaris x86 -> Linux x86 copies. But I'm pretty
sure Sparc & x86 are not compatible endian-wise so hence the data is not
stored the same. Other attempts that have failed -- Linux x86 32bit -->
Linux x86_64.


Vlad Harchev wrote:
> On Sat, Apr 09, 2005 at 08:42:19PM +0200, Peter Eisentraut wrote:
>
>>Vlad Harchev wrote:
>>
>>>I have a quesion - suppose I have sparc box and x86 box running same
>>>release of postgresql compiled with same options. Can I simply copy
>>>database directory between hosts (of course when postgresql server is
>>>stopped on both boxes)?
>>
>>Absolutely not.
>
>
> That's a pity..
> Thanks for your answer!
>