Skip site navigation (1) Skip section navigation (2)

Re: how do I add postgis to an existing postgresql install?

From: Mark Wimer <mwimer(at)usgs(dot)gov>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: how do I add postgis to an existing postgresql install?
Date: 2011-08-11 19:16:36
Message-ID: OFC7526CE6.C8CEB8B4-ON852578E9.00696ADF-852578E9.0069E3D7@usgs.gov (view raw or flat)
Thread:
Lists: pgsql-novice
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 



From:
Brent Dombrowski <brent(dot)dombrowski(at)gmail(dot)com>
To:
Lille Penguini <lille(dot)penguini(at)gmail(dot)com>
Cc:
pgsql-novice(at)postgresql(dot)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(at)postgresql(dot)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.


In response to

pgsql-novice by date

Next:From: Robert FrantzDate: 2011-08-11 20:26:33
Subject: Backup Server Error "might need to increase max_locks_per_transaction"
Previous:From: Brent DombrowskiDate: 2011-08-10 14:42:18
Subject: Re: how do I add postgis to an existing postgresql install?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group