From: | Giuseppe Broccolo <giuseppe(dot)broccolo(at)2ndquadrant(dot)it> |
---|---|
To: | Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com> |
Cc: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: template_postgis issue |
Date: | 2015-05-15 09:58:59 |
Message-ID: | CAFzmHiWZMHsEqaBNYmrwt5ObWKWMz_-TLyAMx=DuN2gMjijUbw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Sachin,
2015-05-15 11:35 GMT+02:00 Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com>:
> Dear Concern,
>
> When I am installing PostgreSQL version 9.1 with PostGIS 1.5 then it's
> creating "template_postgis" database by default.
>
> But when I am installing below PostgreSQL version 9.3 with PostGIS 2.1.7
>
> postgresql-9.3.6-2-windows-x64
> postgis-bundle-pg93x64-setup-2.1.7-1
>
> And PostgreSQL version 9.4 with PostGIS 2.1.7
>
> postgresql-9.4.1-3-windows-x64
> postgis-bundle-pg94x64-setup-2.1.7-1
>
> It's not creating template_postgis by default. Kindly confirm what's
> the problem is.
>
> Note: I am installing these on Windows 7 machine (64 bit)
>
If you are running PostgreSQL 9.1+ you don't need to bother with the
template database, but with the EXTENSION mechanism as introduced from this
release. Please consider the following link:
http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01
In particular, consider this part:
If you are running PostgreSQL 9.1+, we recommend you
don't even bother with the template database and just use
CREATE EXTENSION postgis
in the database of your choosing or use PgAdmin
Extensions install feature which we will cover in this tutorial.
<http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01>
Regards,
--
Giuseppe Broccolo - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
giuseppe(dot)broccolo(at)2ndQuadrant(dot)it | www.2ndQuadrant.it
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Meskes | 2015-05-15 11:10:27 | Re: ECPG SET CONNECTION |
Previous Message | John R Pierce | 2015-05-15 09:52:23 | Re: Restarting DB after moving to another drive |