ImreSamu
commented
3 years ago Thank you !
I can replicate with the alpine based postgis image. ( tested with postgis/postgis:13-3.1-alpine )
probably the current alpine build script is not perfect - I can't see the pcre in ( ./13-3.1/alpine/Dockerfile )
Any suggestions on how to get address_standardizer?
If you can : please use the debian based images ( no alpine in the docker tags );
- imho: with
postgis/postgis:13-3.1- it should work.
my test example:
$ docker run --name pgis_test -e POSTGRES_PASSWORD=M9secret -d postgis/postgis:13-3.1
47f24f227ee82c3c4340ceff6ffd9673dc9aed0aa9cd541caacd3dd2b74f5619
$ docker run --rm -it --link pgis_test:postgres postgis/postgis:13-3.1 \
> sh -c 'PGPASSWORD=M9secret exec psql -h "$POSTGRES_PORT_5432_TCP_ADDR" -p "$POSTGRES_PORT_5432_TCP_PORT" -U postgres'
psql (13.1 (Debian 13.1-1.pgdg100+1))
Type "help" for help.
postgres=# create extension address_standardizer;
CREATE EXTENSION
postgres=# \dx
List of installed extensions
Name | Version | Schema | Description
------------------------+---------+------------+---------------------------------------------------------------------------------------------------------------------
address_standardizer | 3.1.0 | public | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
fuzzystrmatch | 1.1 | public | determine similarities and distance between strings
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
postgis | 3.1.0 | public | PostGIS geometry and geography spatial types and functions
postgis_tiger_geocoder | 3.1.0 | tiger | PostGIS tiger geocoder and reverse geocoder
postgis_topology | 3.1.0 | topology | PostGIS topology spatial types and functions
(6 rows)
postgres=# SELECT num, street, city, zip, zipplus
FROM parse_address('1 Devonshire Place, Boston, MA 02109-1234') AS a;
num | street | city | zip | zipplus
-----+------------------+--------+-------+---------
1 | Devonshire Place | Boston | 02109 | 1234
(1 row)
postgres=# 
rahul-ve
Hi,
Using image postgis:13-master
I was trying to install the extension address_standardizer but was failing with the below error:
ERROR: could not open extension control file "/usr/share/postgresql/13/extension/address_standardizer.control": No such file or directoryand it depends on pcre as described in the docs and during the postgis build, it is supposed to build it if pcre was found to be present. Looks like this was not the case.Any suggestions on how to get address_standardizer?
Thanks Rahul