Talk About Network

Google




Play Stock Market Games
Fantasy Stock Picking Contest

Data Bases > Pgsql General > changing the en...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 15513 of 16301
Post > Topic >>

changing the endianness of a database

by postgres@[EMAIL PROTECTED] ("Chris Saldanha") May 12, 2008 at 04:02 PM

Hi,

We'd like to ****p PostgreSQL as part of a product that runs on both PPC
and
Intel Macs, but the database files are tied to the build settings and
endianness of the computer that the database was initialized on.

Is there any way to cause the server to modify the database files in-place
for endianness issues?  I know that a backup-then-restore process would
fix
the data, but on Macs, many users use Apple's computer migration tools to
copy all their programs/data/users/etc.. to new Macs.

If the user moves from a PPC to an Intel Mac, for instance, the database
would be copied over, but the data would be for the old computer, and the
database won't start.  The backup/restore process is hard for end users,
since they don't understand it -- and they won't contact us until after
the
migration is done, and often not until they've discarded the old computer.

It would be nice if there was a way to recover the data from the existing
database files.

I found this old thread on a related topic, and it seems that this cannot
be
done...
http://archives.postgresql.org/pgsql-general/2008-01/msg00635.php

Thanks,
Chris

--
Chris Saldanha
Parliant Cor****ation
http://www.parliant.com/



-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 6 Posts in Topic:
changing the endianness of a database
postgres@[EMAIL PROTECTED  2008-05-12 16:02:43 
Re: changing the endianness of a database
mmoncure@[EMAIL PROTECTED  2008-05-12 16:20:08 
Re: changing the endianness of a database
craig@[EMAIL PROTECTED]   2008-05-13 04:42:44 
Re: changing the endianness of a database
postgres@[EMAIL PROTECTED  2008-05-12 17:15:01 
Re: changing the endianness of a database
agentm@[EMAIL PROTECTED]   2008-05-12 17:59:06 
Re: changing the endianness of a database
pgsql@[EMAIL PROTECTED]   2008-05-13 09:06:07 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Fri Aug 8 12:50:42 CDT 2008.