[postgis-users] multiple postgis versions on a single instance

[Richard Greenwood]

Thanks Regina, that all makes complete sense.

Rich

On Fri, Oct 9, 2015 at 8:53 PM, Paragon Corporation <lr at pcorp.us> wrote:

> Rich,
>
> > I'm anxious to try postgis 2.2 (Visvalingam-Whyatt being the carrot for
> me).  From my Googling I'm under the impression that I can access multiple
> versions of postgis from a single instance of postgres. Am I correct?
>
> Yes.  I run multiple versions on a single instance all the time.
>
>
>
>
>
> > When I build and install I don't think I need to change the prefix
> because things will go into 2.2 directories, correct?
>
> Correct.  The postgis.control file gets overwritten though, so last
> install becomes the default PostGIS install when you don't explicitly set a
> version and during database restore.
>
>
>
>
>
> > And if my above understanding is correct, then my last question is when
> I create a new database how will I specify the postgis 2.2 extension rather
> than the existing version?
>
>
>
> If PostGIS 2.2.0 is the last install you did, your new database would be
> 2.2.0 with
>
>
>
> CREATE EXTENSION postgis;
>
>
>
> If you don't want that, edit the postgis.control file in share/extension
> folder back to old version.
>
>
>
> To explicitly state the version of PostGIS you want, you would do:
>
>
>
> CREATE EXTENSION postgis VERSION "2.1.8";
>
>
>
> Replacing 2.1.8 with version you want.
>
>
>
>
>
>
>
> >  Sorry, I realize these are pretty noob questions from a guy that's
> been using postgis for a long time...
>
> No need to be sorry. Lots of things change in how to do things and it is
> hard to keep up with changes in both PostGIS and PostgreSQL for anybody.
>
>
>
> > Thanks,
>
> > Rich
>
>
>
> >--
>
> > Richard W. Greenwood, PLS
> > www.greenwoodmap.com
>
>
>
>
>
> Hope that helps,
>
> Regina
>
> http://www.postgis.us
>
> http://postgis.net
>
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>



-- 
Richard W. Greenwood, PLS
www.greenwoodmap.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20151010/65568032/attachment.html>