Thread: How do I include PostGIS geofunctions to a new database after I have already installed PostGIS.

Hi,

I have PostgreSQL 8.4 and I have a database which was created when PostGIS was installed which has the geofunctions within it.

When I try to create a new database it does not include these geofunctions.

How do I include PostGIS geofunctions to a new database after I have already installed PostGIS.

Thanks,

John

--
John J. Mitchell

The simplest trick is to install PostGIS in a blank database and then
use that database as a template hence forth. But how to install
PostGIS at all?

Track down the postgis SQL file (either postgis-1.4.sql or
lwpostgis.sql depending on your version).

createlang plpgsql yourdatabase
psql -f lwpostgis.sql -d yourdatabase
psql -f spatial_ref_sys.sql -d yourdatabase



On Fri, Nov 6, 2009 at 1:22 PM, John Mitchell <mitchelljj98@gmail.com> wrote:
> Hi,
>
> I have PostgreSQL 8.4 and I have a database which was created when PostGIS
> was installed which has the geofunctions within it.
>
> When I try to create a new database it does not include these geofunctions.
>
> How do I include PostGIS geofunctions to a new database after I have already
> installed PostGIS.
>
> Thanks,
>
> John
>
> --
> John J. Mitchell
>