[postgis-users] portable spatial db

[Clay, Bruce]

Thanks Paul, I will try that although I have to admit I am more of a GIS
coder than a DB coder so I will have to start the process to understand
the significance of "instance" in this case.  I know when I connect to
Oracle through GDAL or ArcGis it is the port number.  I assume it is the
same for PG.

Thanks again.

Bruce


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Friday, January 30, 2009 11:57 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] portable spatial db

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)

initdb on your SATA
start your pgsql, with -D to your SATA
load your data
stop your pgsql
remove your SATA

plug it into new machine
start pgsql with -D to your SATA
play



On Fri, Jan 30, 2009 at 8:46 AM, Clay, Bruce <bclay at ball.com> wrote:
> If I build a spatial database on a removable ESATA disk drive, is
there a
> way to use the DB on a different computer with the same version of
postgis?
>
>
>
> Bruce
>
>
>
> 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
>
>
_______________________________________________
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.