PostgreSQL, on top of Debian Wheezy.
docker pull quay.io/aptible/postgresql:${VERSION:-latest}
This is an image conforming to the Aptible database specification. To run a server for development purposes, execute
docker create --name data quay.io/aptible/postgresql
docker run --volumes-from data -e USERNAME=aptible -e PASSPHRASE=pass -e DATABASE=db quay.io/aptible/postgresql --initialize
docker run --volumes-from data -P quay.io/aptible/postgresql
The first command sets up a data container named data which will hold the configuration and data for the database. The second command creates a PostgreSQL instance with a username, passphrase and database name of your choice. The third command starts the database server.
The PostgreSQL server is configured to enforce SSL for any TCP connection. It uses a self-signed certificate generated at startup time, or a certificate / key pair found in SSL_CERTIFICATE and SSL_KEY.
latest: Currently PostgreSQL 1414: PostgreSQL 1413: PostgreSQL 1312: PostgreSQL 1211: PostgreSQL 1110: PostgreSQL 109.6: PostgreSQL 9.69.5: PostgreSQL 9.5 (EOL 2021-02-11)9.4: PostgreSQL 9.4 (EOL 2020-02-13)9.3: PostgreSQL 9.3 (EOL 2018-11-08)
The following extensions are available in all images.
pglogicalpostgis
In the -contrib images, the following extensions are available.
| Extension | Avaiable in versions |
|---|---|
| plpythonu | 9.5 - 11 |
| plpython2u | 9.5 - 11 |
| plpython3u | 9.5 - 12 |
| plperl | 9.5 - 12 |
| plperlu | 9.5 - 12 |
| mysql_fdw | 9.5 - 11 |
| PLV8 | 9.5 - 10 |
| multicorn | 9.5 - 10 |
| wal2json | 9.5 - 12 |
| pg-safeupdate | 9.5 - 11 |
| pg_repack | 9.5 - 13 |
| pgagent | 9.5 - 13 |
| pgaudit | 9.5 - 13 |
| pgcron | 10 |
Aptible Support can update your Database to use the --contrib image.
Tests are run as part of the Dockerfile build. To execute them separately within a container, run:
bats test
To push the Docker image to Quay, run the following command:
make release
Images are built and pushed to Docker Hub on every deploy. Because Quay currently only supports build triggers where the Docker tag name exactly matches a GitHub branch/tag name, we must run the following script to synchronize all our remote branches after a merge to master:
make sync-branches
MIT License, see LICENSE for details.
Copyright (c) 2019 Aptible and contributors.