Bruce, Have you taken a look at PortableGIS? It has a USB version of PostgreSQL with a bunch of other popular Open Source GIS tools.
Might be ideal for what you are doing. Though I think its only windows version. http://www.archaeogeek.com/blog/portable-gis/ hope that helps, Regina -----Original Message----- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Paul Ramsey Sent: Friday, January 30, 2009 12:16 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] portable spatial db Yes, each port maps to an instance (a running copy of pgsql), and an instance contains many databases. You've got it. P On Fri, Jan 30, 2009 at 9:08 AM, Clay, Bruce <bc...@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-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@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 <bc...@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@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> > _______________________________________________ > postgis-users mailing list > postgis-users@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@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users