pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
can be database files be copied using 'cp' between hosts with different endianess?
4+ messages / 3 participants
[nested] [flat]

* can be database files be copied using 'cp' between hosts with different endianess?
@ 2005-04-09 17:03  Vlad Harchev <hvv@hippo.ru>
  0 siblings, 1 reply; 4+ messages in thread

From: Vlad Harchev @ 2005-04-09 17:03 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: can be database files be copied using 'cp' between hosts with different endianess?
@ 2005-04-09 18:42  Peter Eisentraut <peter_e@gmx.net>
  parent: Vlad Harchev <hvv@hippo.ru>
  0 siblings, 1 reply; 4+ messages in thread

From: Peter Eisentraut @ 2005-04-09 18:42 UTC (permalink / raw)
  To: Vlad Harchev <hvv@hippo.ru>; +Cc: pgsql-admin

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/



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: can be database files be copied using 'cp' between hosts with different endianess?
@ 2005-04-09 19:23  Vlad Harchev <hvv@hippo.ru>
  parent: Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 4+ messages in thread

From: Vlad Harchev @ 2005-04-09 19:23 UTC (permalink / raw)
  To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: can be database files be copied using 'cp' between hosts with
@ 2005-04-10 09:47  William Yu <wyu@talisys.com>
  parent: Vlad Harchev <hvv@hippo.ru>
  0 siblings, 0 replies; 4+ messages in thread

From: William Yu @ 2005-04-10 09:47 UTC (permalink / raw)
  To: Vlad Harchev <hvv@hippo.ru>

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!
> 



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2005-04-10 09:47 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-09 17:03 can be database files be copied using 'cp' between hosts with different endianess? Vlad Harchev <hvv@hippo.ru>
2005-04-09 18:42 ` Peter Eisentraut <peter_e@gmx.net>
2005-04-09 19:23   ` Vlad Harchev <hvv@hippo.ru>
2005-04-10 09:47     ` Re: can be database files be copied using 'cp' between hosts with William Yu <wyu@talisys.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox