[postgis-users] portable spatial db

Clay, Bruce bclay at ball.com
Fri Jan 30 10:02:36 PST 2009


The systems are all PC's of various sizes so the endianness will be the
same.  Is there a problem though with operating system version (i.e.
Windows XP vs. Vista vs. Linux?  I am avoiding Unicode although I did
find that some of the geonames data has embedded Unicode attributes.
For the time being I stripped that off but it takes away some of the
native language information.  Geonames.org data also has a lot of
symbols that my code is not too happy with.


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Greg
Sent: Friday, January 30, 2009 12:24 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] portable spatial db

Paul Ramsey <pramsey at opengeo.org> writes:

> If the versions are the same, you should be able to move the instance
> from place to place (note, I say "instance" not database, instances
> are the collections of databases that reside in one data area)

Is it necessary that the other machine have the same endianness, sizes
of integral types, cpu type, etc?  Or is everything in the db files
using network order and fixed width types?
postgis-users mailing list
postgis-users at postgis.refractions.net

This message and any enclosures are intended only for the addressee.  Please  
notify the sender by email if you are not the intended recipient.  If you are  
not the intended recipient, you may not use, copy, disclose, or distribute this  
message or its contents or enclosures to any other person and any such actions  
may be unlawful.  Ball reserves the right to monitor and review all messages  
and enclosures sent to or from this email address.

More information about the postgis-users mailing list