1

As newbie with PostGIS, I downloaded Postgresapp for MacOSX. Everything works fine, but I noticed some differences with Stackbuilder which adds to extensions address_normalizer and pgRouting.

Can I add those extensions or are they not necessary?

If necessary how can I add them?

2 Answers 2

1

I cannot answer if you need those extensions or not. To add it to a database, you need to install the package of the extension and execute it on psql:

\c your_database_name;
create extension address_normalizer;
1

It depends what you want to do:

I don't think Postgresapp comes packaged with address_standardizer or pgRouting, so no you can't install those via CREATE EXTENSION and really can't install them at all unless you compile them.

pgRouting is for network routing, so if you have no need for building trip navigation, you probably don't need it. Most people start with PostGIS before they start using pgRouting.

address_Standardizer: is for address standardization and was a separate module, that windows stackbuilder ships. No other distro to my knowledge ships it. This was merged into the PostGIS code base in PostGIS 2.2, so when 2.2 is released, most distributions should carry it. Again don't need this for normal PostGIS functioning and is used as an alternative address normalizer for tiger geocoder.

So the PostGIS related extensions you can install with PostgresApp are

postgis postgis_topology postgis_tiger_geocoder

Postgresapp has the other usual PostgreSQL extensions like hstore etc. And it has PL/V8 which is cool. To see what you have available (and already installed) to you as extensions run the query:

SELECT * FROM pg_available_extensions;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.