search

bcgov / patroni-postgres-container

Patroni Postgres container based of the oficial Postgres images from Docker Hub
Apache License 2.0
4 stars 14 forks source link

Added postgis support to docker image #15

Open bashbang opened 1 year ago

bashbang commented 1 year ago

This installs the following additional support:

postgresql-postgis: support for geographic objects postgresql-12-pgrouting: routing and other network analysis functionality to PostGIS postgresql-contrib: advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions postgresql-12-pg-qualstats: PostgreSQL extension keeping statistics on predicates found in WHERE statements and JOIN clauses. This is useful if you want to be able to analyze what are the most-often executed quals (predicates) on your database

These modules still need a "CREATE" in the runtime PSQL service which is an optional task for the consumer of this image.

bashbang commented 1 year ago

@caggles any issues with getting this added to the standard PSQL image?

bashbang commented 1 year ago

@caggles @ShellyXueHan ...poke...