[postgis-users] SQL vs. Extensions

Rémi Cura remi.cura at gmail.com
Tue Jun 2 01:16:12 PDT 2015


Counting all the functions doesn't make sense, you might have a lot if user
defined functions, or a number of function depending if you also install
the legacy functions, etc.


The Postgis functions get into the public schema, you should have about
1100 functions.
The Postgis topology functions get into the topology schema(about 100
functions).
I don't use pgrouting.


As far as I know, currently the preferred method of install is using the
EXTENSION mechanism, which has many advantages (object protected, easy
update, easier management).

If you are not sure of your postgis, you can either check your
build/install (make test)
and use
------
SELECT postgis_full_version()
-----

Which tells you what is installed.

When you use the
------
CREATE EXTENSION postgis
------
if you have no error, you should have no reason to think you miss something.

Cheers,
Rémi-C

2015-06-02 1:15 GMT+02:00 Yoder, Andrew (AYODER) <AYODER at arinc.com>:

>  Hello,
>
>  I am a Postgres DBA, new to PostGIS, working at a company that uses
> PostGIS.  I am building a new database using PostgreSQL 9.4 and PostGIS
> 2.1.
>
>  My question:
>
>  Previously the databases here have been built by installing the
> PostgreSQL and PostGIS packages, and then running the postgis.sql and
> spatial_ref_sys.sql scripts provided by the install.  I am experimenting
> with installing PostGIS via extensions only.  To test, I installed two
> databases using PostgreSQL 9.4, one the old way of installing the packages
> and running the scripts, and one with the packages and using the postgis,
> postgis_tiger_geocoder,  and postgis_topology extensions – both were into a
> newly created template_gis database.   The issue is I do not believe I have
> installed everything that needs to be installed.  Building the database
> using the first method yielded an install with 3258 functions owned by
> postgres user.  Using the extensions approach I have only 2685.  There may
> be more items missing – this is all I compared before searching for
> information on the internet.  From the extensions portion of the manual, it
> only mentioned using postgis and postgis_topology (with tiger geocoder
> appearing to be an “extra”).
>
>  Please forgive the crude comparisons done.  Any input on what I am
> missing, or if the lesser number of functions is “normal” would be
> appreciated.
>
>  Sincerely,
>
>  Andy Yoder
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150602/7de28415/attachment.html>


More information about the postgis-users mailing list