[postgis-users] portable spatial db

[David Fawcett]

An Oracle instance only has one db, so your thinking is correct.



On Jan 30, 2009, at 11:08 AM, "Clay, Bruce" <bclay at ball.com> wrote:

> 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.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users