Maintenance scripts to generate Immutable Application Containers for all PostgreSQL versions based on:
- Red Hat Universal Base Images (UBI) 8 - default
- Debian Slim base images, with and without the PostGIS extension:
- PostgreSQL 10 and 11 on Debian Stretch (9) Slim
- PostgreSQL 12 and 13 on Debian Buster (10) Slim
These images are customised to work with Cloud Native PostgreSQL operators by EDB for Kubernetes and Red Hat Openshift.
It is also possible to run them directly with Docker, for PostgreSQL evaluation and testing purposes only.
The images include:
- PostgreSQL
- Barman Cloud
- PostGIS 3.1 (optional, on Debian based images only)
PostgreSQL is distributed by the PGDG under the PostgreSQL License.
Barman Cloud is distributed by EnterpriseDB under the GNU GPL 3 License.
PostGIS is distributed under the GNU GPL 2 License.
Images are available via Quay.io.
The Docker entry point is based on Docker Postgres distributed by the PostgreSQL Docker Community under MIT license.
The image can be pulled with the docker pull command, following the instructions you
find in the Quay.io repository.
For example you can pull the latest minor version of the latest major version of PostgreSQL based on RedHat UBI with the following command:
docker pull quay.io/enterprisedb/postgresqlIf you want to use the latest minor version of a particular major version of PostgreSQL, for example 12, on UBI you can type:
docker pull quay.io/enterprisedb/postgresql:12In order to install the latest minor version of PostgreSQL 12 on a Debian based image, you can type:
docker pull quay.io/enterprisedb/postgresql:12-debianIMPORTANT: in the examples below we assume that the latest minor of the latest major version is used.
$ docker run -d \
--name some-postgres \
-e POSTGRES_PASSWORD=mysecretpassword \
quay.io/enterprisedb/postgresqlThe default postgres user and database are created in the entrypoint with initdb.
The postgres database is a default database meant for use by users, utilities and third party applications.
You can spin up a disposable PostgreSQL database and run queries using the psql command line client utility with:
$ docker run -it --rm \
--network some-network \
quay.io/enterprisedb/postgresql \
psql -h some-postgres -U postgres
psql (13.1)
Type "help" for help.
postgres=# SELECT 1;
?column?
----------
1
(1 row)