[postgis-users] portable spatial db

[Paul Ramsey]

On Fri, Jan 30, 2009 at 10:02 AM, Clay, Bruce <bclay at ball.com> wrote:
> Paul:
>
> 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'd experiment a bit first on that :) I don't know how much
"windowsness" gets baked into windows builds.

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

Why did you strip the unicode? Once you have it inside the database in
unicode, it's very easy to get out other encodings, withe
PGCLIENTENCODING settings...

P

>
> Bruce
>
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Greg
> Troxel
> 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
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> 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.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>