<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;">
<div>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). </div>
<div><br>
</div>
<div>Thanks.</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span>Rémi Cura <<a href="mailto:remi.cura@gmail.com">remi.cura@gmail.com</a>><br>
<span style="font-weight:bold">Reply-To: </span>PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br>
<span style="font-weight:bold">Date: </span>Tuesday, June 2, 2015 at 4:16 AM<br>
<span style="font-weight:bold">To: </span>PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br>
<span style="font-weight:bold">Subject: </span>Re: [postgis-users] SQL vs. Extensions<br>
</div>
<div><br>
</div>
<div>
<div>
<div dir="ltr">
<div class="gmail_default" style="font-family:monospace,monospace">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.<br>
<br>
</div>
<div class="gmail_default" style="font-family:monospace,monospace"><br>
The Postgis functions get into the public schema, you should have about 1100 functions.<br>
The Postgis topology functions get into the topology schema(about 100 functions).<br>
</div>
<div class="gmail_default" style="font-family:monospace,monospace">I don't use pgrouting.<br>
<br>
</div>
<div class="gmail_default" style="font-family:monospace,monospace"><br>
</div>
<div class="gmail_default" style="font-family:monospace,monospace">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).<br>
<br>
</div>
<div class="gmail_default" style="font-family:monospace,monospace">If you are not sure of your postgis, you can either check your build/install (make test)<br>
</div>
<div class="gmail_default" style="font-family:monospace,monospace">and use <br>
</div>
<div class="gmail_default" style="font-family:monospace,monospace">------<br>
SELECT postgis_full_version()<br>
-----<br>
<br>
</div>
<div class="gmail_default" style="font-family:monospace,monospace">Which tells you what is installed.<br>
<br>
</div>
<div class="gmail_default" style="font-family:monospace,monospace">When you use the
<br>
------<br>
CREATE EXTENSION postgis<br>
</div>
<div class="gmail_default" style="font-family:monospace,monospace">------<br>
</div>
<div class="gmail_default" style="font-family:monospace,monospace">if you have no error, you should have no reason to think you miss something.<br>
</div>
<div class="gmail_default" style="font-family:monospace,monospace"><br>
</div>
<div class="gmail_default" style="font-family:monospace,monospace">Cheers,<br>
</div>
<div class="gmail_default" style="font-family:monospace,monospace">Rémi-C<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2015-06-02 1:15 GMT+02:00 Yoder, Andrew (AYODER) <span dir="ltr">
<<a href="mailto:AYODER@arinc.com" target="_blank">AYODER@arinc.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word;color:rgb(0,0,0);font-size:14px;font-family:Calibri,sans-serif">
<div>Hello,</div>
<div><br>
</div>
<div>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. </div>
<div><br>
</div>
<div>My question: </div>
<div><br>
</div>
<div>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”). </div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Sincerely,</div>
<div><br>
</div>
<div>Andy Yoder</div>
</div>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</span>
</body>
</html>