PostGIS is the best Geospatial DB solution for applications besides the geographic world. This article is a guide for building the environment of PostgreSQL 13 with PostGIS and PgAdmin 4 using Docker on Mac. I assume you have already installed Docker on your Mac so just introduce how to install PostGIS and PgAdmin 4.
- Create a new Docker network
$docker network create --driver bridge postgis-network
2. Create the new PostGIS Docker container with the above network
docker run --name postgis -p 5432:5432 -e POSTGRES_PASSWORD=123456 --hostname postgis --network postgis-network --detach postgis/postgis
3. Create the new PgAdmin4 Docker container with the above network
docker run --name pgadmin4 -p 5050:80 -e "PGADMIN_DEFAULT_EMAILemail@example.com" -e "PGADMIN_DEFAULT_PASSWORD=123456" --hostname pgadmin4 --network postgis-network --detach dpage/pgadmin4
4. Open the installed PgAdmin in the browser, then login and connect the PostGIS server.
Execute the query “SELECT * FROM pg_available_extensions;”, we can then available PostGIS extensions in the list.
Open PostGIS extension in the specific database
CREATE EXTENSION postgis; CREATE EXTENSION postgis_raster; -- Enable Topology CREATE EXTENSION postgis_topology; -- Enable PostGIS Advanced 3D -- and other geoprocessing algorithms -- sfcgal not available with all distributions CREATE EXTENSION postgis_sfcgal; -- fuzzy matching needed for Tiger CREATE EXTENSION fuzzystrmatch; -- rule based standardizer CREATE EXTENSION address_standardizer; -- example rule data set CREATE EXTENSION address_standardizer_data_us; -- Enable US Tiger Geocoder CREATE EXTENSION postgis_tiger_geocoder;
Now, you have successfully opened PostGIS in the database, you can execute the following query to check
One reply on “Install PostgreSQL 13 with PostGIS and PgAdmin 4 with Docker on Mac”
[…] https://osm2pgsql.org/doc/install.html, for PostGIS, you can refer to my previous post “Install PostgreSQL 13 with PostGIS and PgAdmin 4 with Docker on Mac” if your laptop is […]