[postgis-users] SQL vs. Extensions

[Yoder, Andrew (AYODER)]

Thanks for the quick response.  My only reason to expect there was an issue with comparing function counts is because there isn’t any user defined data/functions in the database yet.  It is strictly a (software installation + run the postgis scripts) vs. (software installation + create the extensions).

Thanks.

From: Rémi Cura <remi.cura at gmail.com<mailto:remi.cura at gmail.com>>
Reply-To: PostGIS Users Discussion <postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>>
Date: Tuesday, June 2, 2015 at 4:16 AM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>>
Subject: Re: [postgis-users] SQL vs. Extensions

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<mailto: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<mailto: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/f1a2707a/attachment.html>