[postgis-users] portable spatial db

[RAVI KUMAR]

Just to clarify..

I always do..
Shape (file) --> PostGIS {Complete Analysis}
PostGIS --> Shape (file) 
Use it to transfer to any computer... or on a Pen Drive etc

If there is any simpler way .. Just in case..

Cheers

Ravi Kumar         


--- On Fri, 1/30/09, Paul Ramsey <pramsey at opengeo.org> wrote:

> From: Paul Ramsey <pramsey at opengeo.org>
> Subject: Re: [postgis-users] portable spatial db
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Date: Friday, January 30, 2009, 10:46 PM
> Yes, each port maps to an instance (a running copy of
> pgsql), andTake it to any other system an
> instance contains many databases. You've got it.
> 
> P
> 
> On Fri, Jan 30, 2009 at 9: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
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users