An Oracle instance only has one db, so your thinking is correct.
On Jan 30, 2009, at 11:08 AM, "Clay, Bruce" <[email protected]> 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: [email protected]
[mailto:[email protected]] 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 <[email protected]> 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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
