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
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.
Brent Dombrowski <brent(dot)dombrowski(at)gmail(dot)com>
Lille Penguini <lille(dot)penguini(at)gmail(dot)com>
08/10/2011 10:42 AM
Re: [NOVICE] how do I add postgis to an existing postgresql install?
On Aug 9, 2011, at 6:49 PM, Lille Penguini wrote:
> Two things, dear reader:
> 1) how can I be sure postgis was not included in my postgresql install,
> 2) if it wasn't how can I add postgis to my exisiting install?
I would start by reading up on PostGIS at their web site:
They have the PostGIS documentation, install instructions, and mailing
lists for PostGIS.
In response to
pgsql-novice by date
|Next:||From: Robert Frantz||Date: 2011-08-11 20:26:33|
|Subject: Backup Server Error "might need to increase max_locks_per_transaction"|
|Previous:||From: Brent Dombrowski||Date: 2011-08-10 14:42:18|
|Subject: Re: how do I add postgis to an existing postgresql install?|