PostgreSQL image based on postgis/postgis, with quite a few added extensions

Tag labels follow the pattern X-Y.Z, where X is the major Postgres version (starting from version 12) and Y.Z is the major.minor Postgis version.

The latest tag currently corresponds to 16-3.4.

Usage

In order to run a basic container capable of serving a Postgres database with all extensions below available:

docker run -e POSTGRES_PASSWORD=mysecretpassword -d ivanlonel/postgis-with-extensions

Here is a sample docker-compose stack definition, which includes a powa-web container and a pgadmin container. The Postgres container is built from a Dockerfile that extends this image by running localedef in order to ensure Postgres will use the locale specified in docker-compose.yml.

For more detailed instructions about how to start and control your Postgres container, see the documentation for the postgres image here.

Available extensions

• postgis
• asn1oid
• ddlx
• extra_window_functions
• first_last_agg
• h3-pg
• hll
• hypopg
• icu_ext
• ip4r
• jsquery
• mysql_fdw
• numeral
• ogr_fdw
• oracle_fdw
• orafce
• periods
• pgagent
• pgaudit
• pgauditlogtofile
• pgfincore
• pglogical
• pglogical_ticker
• pgl_ddl_deploy
• pgmemcache
• pgmp
• pgpcre
• pgq
• pgq_node
• pgrouting
• pgtap
• pguint
• pgvector
• pg_cron
• pg_dirtyread
• pg_fact_loader
• pg_qualstats
• pg_rational
• pg_repack
• pg_show_plans
• pg_similarity
• pg_stat_kcache
• pg_track_settings
• pg_uuidv7
• pg_wait_sampling
• pldebugger (pldbgapi)
• PL/Perl
• plpgsql_check
• PL/Proxy
• PL/Python
• PL/sh
• pointcloud
• postgresql-debversion
• powa (archivist)
• prefix
• prioritize
• q3c
• rum
• semver
• sqlite_fdw
• table_log
• tdigest
• tds_fdw
• timescaledb
• toastinfo
• unit