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@xxxxxxxxx> 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 > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
