crunchy-postgres-gis

PostgreSQL (pronounced “post-gress-Q-L”) is an open source, ACID compliant, relational database management system (RDBMS) developed by a worldwide team of volunteers. The crunchy-postgres-gis container image is unmodified, open source PostgreSQL packaged and maintained by professionals. This image is identical to the crunchy-postgres image except it includes the open source geospatial extension PostGIS for PostgreSQL in addition to the language extension PL/R which allows for writing functions in the R statistical computing language.

Features

The following features are supported by the crunchy-postgres-gis container:

• Kubernetes and OpenShift secrets
• Backup and restoration from various tools: pgbackrest, pg_basebackup and pg_dump/pg_restore.
• Custom mounted configuration files (see below)
• Async and Sync Replication
• PostGIS
• PL/R

Packages

The crunchy-postgres-gis Docker image contains the following packages (versions vary depending on PostgreSQL version):

• PostgreSQL (12.2, 11.7, 10.12, 9.6.17 and 9.5.21)
• pgBackRest (2.25)
• CentOS7 - publicly available
• UBI7 - customers only

Environment Variables

Required

Optional

Volumes

Custom Configuration

The following configuration files can be mounted to the /pgconf volume in the crunchy-postgres container to customize the runtime:

Verifying PL/R

In order to verify the successful initialization of the PL/R extension, the following commands can be run:

create extension plr;
SELECT * FROM plr_environ();
SELECT load_r_typenames();
SELECT * FROM r_typenames();
SELECT plr_array_accum('{23,35}', 42);
CREATE OR REPLACE FUNCTION plr_array (text, text)
RETURNS text[]
AS '$libdir/plr','plr_array'
LANGUAGE 'c' WITH (isstrict);
select plr_array('hello','world');