Thread: how do I add postgis to an existing postgresql install?
Hi,
Two things, dear reader:
1) how can I be sure postgis was not included in my postgresql install, and
2) if it wasn't how can I add postgis to my exisiting install?
Thanks,
Lille
On Aug 9, 2011, at 6:49 PM, Lille Penguini wrote: > Hi, > > Two things, dear reader: > > 1) how can I be sure postgis was not included in my postgresql install, and > 2) if it wasn't how can I add postgis to my exisiting install? > > Thanks, > > Lille I would start by reading up on PostGIS at their web site: http://postgis.refractions.net/ They have the PostGIS documentation, install instructions, and mailing lists for PostGIS. Brent.
Lillie,
When postGIS installs, it puts a template database into your PG installation: "template_postgis". I don't know whether it always shows up in your database list by default, but if you go to add a new database to PostgreSQL, and if template_postgis isn't there, then PostGIS isn't installed.
Once you download and install PostGIS from teh site Brent mentioned, that's how the functionality is added to a database most easily; by starting a database with that template; all the postGIS functions and a couple of tables will then be present in the public schema of the database. This does not add PostGIS functionality directly to existing databases; that's a different process.
hth,
Mark
On Aug 9, 2011, at 6:49 PM, Lille Penguini wrote:
> Hi,
>
> Two things, dear reader:
>
> 1) how can I be sure postgis was not included in my postgresql install, and
> 2) if it wasn't how can I add postgis to my exisiting install?
>
> Thanks,
>
> Lille
I would start by reading up on PostGIS at their web site: http://postgis.refractions.net/
They have the PostGIS documentation, install instructions, and mailing lists for PostGIS.
Brent.
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
When postGIS installs, it puts a template database into your PG installation: "template_postgis". I don't know whether it always shows up in your database list by default, but if you go to add a new database to PostgreSQL, and if template_postgis isn't there, then PostGIS isn't installed.
Once you download and install PostGIS from teh site Brent mentioned, that's how the functionality is added to a database most easily; by starting a database with that template; all the postGIS functions and a couple of tables will then be present in the public schema of the database. This does not add PostGIS functionality directly to existing databases; that's a different process.
hth,
Mark
| From: | Brent Dombrowski <brent.dombrowski@gmail.com> |
| To: | Lille Penguini <lille.penguini@gmail.com> |
| Cc: | pgsql-novice@postgresql.org |
| Date: | 08/10/2011 10:42 AM |
| Subject: | Re: [NOVICE] how do I add postgis to an existing postgresql install? |
| Sent by: | pgsql-novice-owner@postgresql.org |
On Aug 9, 2011, at 6:49 PM, Lille Penguini wrote:
> Hi,
>
> Two things, dear reader:
>
> 1) how can I be sure postgis was not included in my postgresql install, and
> 2) if it wasn't how can I add postgis to my exisiting install?
>
> Thanks,
>
> Lille
I would start by reading up on PostGIS at their web site: http://postgis.refractions.net/
They have the PostGIS documentation, install instructions, and mailing lists for PostGIS.
Brent.
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice