Chainguard Container for postgis

PostGIS extends the capabilities of the PostgreSQL relational database by adding support for storing, indexing, and querying geospatial data

Chainguard Containers are regularly-updated, secure-by-default container images.

Download this Container Image

For those with access, this container image is available on cgr.dev:

docker pull cgr.dev/ORGANIZATION/postgis:latest

Be sure to replace the ORGANIZATION placeholder with the name used for your organization's private repository within the Chainguard Registry.

This image uses the Chainguard PostgreSQL image as a base and includes the postgis extension to support storing geospatial data.

The image's default docker-entrypoint.sh script will automatically load the extension the first time it is run. For example:

docker run --name postgis --rm -t -e POSTGRES_HOST_AUTH_METHOD=trust cgr.dev/ORGANIZATION/postgis:latest

Will show output like the following:

/usr/bin/docker-entrypoint.sh: sourcing /var/lib/postgres/initdb/10_postgis.sh
CREATE DATABASE
Loading PostGIS extensions into template_postgis
CREATE EXTENSION
CREATE EXTENSION
You are now connected to database "template_postgis" as user "postgres".
CREATE EXTENSION
CREATE EXTENSION
Loading PostGIS extensions into postgres
CREATE EXTENSION
CREATE EXTENSION
You are now connected to database "postgres" as user "postgres".
CREATE EXTENSION
CREATE EXTENSION

This output indicates that the extension has been installed into the running PostgreSQL instance.

Verify the extension is installed by running the following:

 docker exec -it postgis psql -U postgres -c '\dx'
                                        List of installed extensions
          Name          | Version |   Schema   |                        Description
------------------------+---------+------------+------------------------------------------------------------
 fuzzystrmatch          | 1.2     | public     | determine similarities and distance between strings
 plpgsql                | 1.0     | pg_catalog | PL/pgSQL procedural language
 postgis                | 3.5.0   | public     | PostGIS geometry and geography spatial types and functions
 postgis_tiger_geocoder | 3.5.0   | tiger      | PostGIS tiger geocoder and reverse geocoder
 postgis_topology       | 3.5.0   | topology   | PostGIS topology spatial types and functions
(5 rows)

Note the installed postgis, postgis_tiger_geocoder, and postgis_topology extensions.

Refer to the Getting Started with the PostgreSQL Chainguard Image guide for more information on how to use the base PostgreSQL image that this is built on.

For PostGIS specific guides, refer to the official PostGIS Getting Started pages.

What are Chainguard Containers?

Chainguard Containers are minimal container images that are secure by default.

In many cases, the Chainguard Containers tagged as :latest contain only an open-source application and its runtime dependencies. These minimal container images typically do not contain a shell or package manager. Chainguard Containers are built with Wolfi, our Linux undistro designed to produce container images that meet the requirements of a more secure software supply chain.

The main features of Chainguard Containers include:

• Minimal design, without unnecessary software bloat
• Daily builds to ensure container images are up-to-date with available security patches
• High quality build-time SBOMs attesting to the provenance of all artifacts within the image
• Verifiable signatures provided by Sigstore
• Reproducible builds with Cosign and apko (read more about reproducibility)

For cases where you need container images with shells and package managers to build or debug, most Chainguard Containers come paired with a -dev variant.

Although the -dev container image variants have similar security features as their more minimal versions, they feature additional software that is typically not necessary in production environments. We recommend using multi-stage builds to leverage the -dev variants, copying application artifacts into a final minimal container that offers a reduced attack surface that won’t allow package installations or logins.

Learn More

To better understand how to work with Chainguard Containers, please visit Chainguard Academy and Chainguard Courses.

In addition to Containers, Chainguard offers VMs and Libraries. Contact Chainguard to access additional products.

Trademarks

This software listing is packaged by Chainguard. The trademarks set forth in this offering are owned by their respective companies, and use of them does not imply any affiliation, sponsorship, or endorsement by such companies.