PostgreSQL on Docker
Switch branches/tags
Nothing to show
Clone or download
almathew Merge pull request #67 from almathew/wal2json
Add wal2json output plugin.
Latest commit 3edfe93 Sep 7, 2018
Permalink
Failed to load latest commit information.
.docker Import Travis scaffolding Feb 10, 2016
10-contrib Add wal2json to each PostgreSQL version that support it, and update t… Sep 5, 2018
10-pg_cron Add wal2json to each PostgreSQL version that support it, and update t… Sep 5, 2018
10 Add wal2json to each PostgreSQL version that support it, and update t… Sep 5, 2018
9.3-contrib Add wal2json to each PostgreSQL version that support it, and update t… Sep 5, 2018
9.3 Add wal2json to each PostgreSQL version that support it, and update t… Sep 5, 2018
9.4-contrib Add wal2json to each PostgreSQL version that support it, and update t… Sep 5, 2018
9.4 Add wal2json to each PostgreSQL version that support it, and update t… Sep 5, 2018
9.5-contrib Add wal2json to each PostgreSQL version that support it, and update t… Sep 5, 2018
9.5-pg_cron Add wal2json to each PostgreSQL version that support it, and update t… Sep 5, 2018
9.5 Add wal2json to each PostgreSQL version that support it, and update t… Sep 5, 2018
9.6-contrib Add wal2json to each PostgreSQL version that support it, and update t… Sep 5, 2018
9.6 Add wal2json to each PostgreSQL version that support it, and update t… Sep 5, 2018
bin Auto-configure from APTIBLE_CONTAINER_SIZE Nov 22, 2017
templates/etc Auto-configure from APTIBLE_CONTAINER_SIZE Nov 22, 2017
test Pin Python version to 2.7 for sslyze. Sep 6, 2018
.gitignore Import Travis scaffolding Feb 10, 2016
.travis.yml Add 10-contrib tag Mar 5, 2018
Dockerfile.erb Auto-configure from APTIBLE_CONTAINER_SIZE Nov 22, 2017
LICENSE.md Initial commit Mar 18, 2014
Makefile Update makefile Mar 5, 2018
README.md Postgres 10 Oct 9, 2017
config.mk Import Travis scaffolding Feb 10, 2016
latest.mk Postgres 10 Oct 9, 2017
test-replication.sh Support clean restarts Aug 5, 2016
test-restart.sh Support clean restarts Aug 5, 2016
test-ssl.sh Add tests for supported protocols. Jul 24, 2018
test.sh Add tests for supported protocols. Jul 24, 2018

README.md

aptible/postgresql

Docker Repository on Quay.io Build Status

PostgreSQL, on top of Debian Wheezy.

Installation and Usage

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.

SSL

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.

Available Versions (Tags)

  • latest: Currently PostgreSQL 10
  • 10: PostgreSQL 10
  • 9.6: PostgreSQL 9.6
  • 9.5: PostgreSQL 9.5
  • 9.4: PostgreSQL 9.4
  • 9.3: PostgreSQL 9.3

Tests

Tests are run as part of the Dockerfile build. To execute them separately within a container, run:

bats test

Deployment

To push the Docker image to Quay, run the following command:

make release

Continuous Integration

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

Copyright and License

MIT License, see LICENSE for details.

Copyright (c) 2015 Aptible and contributors.

@fancyremarker