Maintenance scripts to generate Immutable Application Containers for all available PostgreSQL + PostGIS versions (12 to 17) to be used as operands with the CloudNativePG operator for Kubernetes.
These images are built on top of the PostGIS image (Debian version), by adding the following software:
Barman Cloud is distributed by EnterpriseDB under the GNU GPL 3 License.
PGAudit is distributed under the PostgreSQL License.
Postgres Failover Slots is distributed by EnterpriseDB under the PostgreSQL License.
pgRouting is distributed under the GNU GPL 2 License, with the some Boost extensions being available under Boost Software License.
Licensing information of all the software included in the container images is
in the /usr/share/doc/*/copyright* files.
Images are available via the GitHub Container Registry.
The following example shows how you can easily create a new PostgreSQL 17
cluster with PostGIS 3.4 in it. All you have to do is set the imageName
accordingly. Please look at the registry for a list of available images
and select the one you need.
Create a YAML manifest. For example, you can put the YAML below into a file
named postgis.yaml (any name is fine). (Please refer to
CloudNativePG for details on the API):
apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
name: cluster-example
spec:
instances: 3
imageName: ghcr.io/cloudnative-pg/postgis:17-3.4
bootstrap:
initdb:
postInitTemplateSQL:
- CREATE EXTENSION postgis;
- CREATE EXTENSION postgis_topology;
- CREATE EXTENSION fuzzystrmatch;
- CREATE EXTENSION postgis_tiger_geocoder;
storage:
size: 1GiThen run kubectl apply -f postgis.yaml.
When the cluster is up, run the following command to verify the version of
PostGIS that is available in the system, by connecting to the app database:
$ kubectl exec -ti cluster-example-1 -- psql app
psql (17.0 (Debian 17.0-1.pgdg110+1))
Type "help" for help.
app=# SELECT * FROM pg_available_extensions WHERE name ~ '^postgis' ORDER BY 1;
name | default_version | installed_version | comment
--------------------------+-----------------+-------------------+------------------------------------------------------------
postgis | 3.4.0 | | PostGIS geometry and geography spatial types and functions
postgis-3 | 3.4.0 | | PostGIS geometry and geography spatial types and functions
postgis_raster | 3.4.0 | | PostGIS raster types and functions
postgis_raster-3 | 3.4.0 | | PostGIS raster types and functions
postgis_sfcgal | 3.4.0 | | PostGIS SFCGAL functions
postgis_sfcgal-3 | 3.4.0 | | PostGIS SFCGAL functions
postgis_tiger_geocoder | 3.4.0 | | PostGIS tiger geocoder and reverse geocoder
postgis_tiger_geocoder-3 | 3.4.0 | | PostGIS tiger geocoder and reverse geocoder
postgis_topology | 3.4.0 | | PostGIS topology spatial types and functions
postgis_topology-3 | 3.4.0 | | PostGIS topology spatial types and functions
(10 rows)The following command shows the extensions installed in the app database,
thanks to the postInitTemplateSQL section in the bootstrap which runs the
selected CREATE EXTENSION commands in the template1 database, which is
inherited by the application database - called app and created by default by
CloudNativePG.
app=# \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.4.0 | public | PostGIS geometry and geography spatial types and functions
postgis_tiger_geocoder | 3.4.0 | tiger | PostGIS tiger geocoder and reverse geocoder
postgis_topology | 3.4.0 | topology | PostGIS topology spatial types and functions
(5 rows)You can now enjoy PostGIS!
This software is available under Apache License 2.0.
Copyright The CloudNativePG Contributors.
Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.