docker-postgresql

Docker container for PostgreSQL Server based on madharjan/docker-base

Features

• Environment variables to create database, user and set password
• Bats bats-core/bats-core based test cases

PostgreSQL Server 9.5 (docker-postgresql)

Environment

Variable	Default	Example
DISABLE_POSTGRESQL	0	1 (to disable)
POSTGRESQL_DATABASE	postgres	mydb
POSTGRESQL_USERNAME	postgres	myuser
POSTGRESQL_PASSWORD		mypass

Build

# clone project
git clone https://github.com/madharjan/docker-postgresql
cd docker-postgresql

# build
make

# tests
make run
make test

# clean
make clean

Run

Note: update environment variables below as necessary

# prepare foldor on host for container volumes
sudo mkdir -p /opt/docker/postgresql/etc/
sudo mkdir -p /opt/docker/postgresql/lib/
sudo mkdir -p /opt/docker/postgresql/log/

# stop & remove previous instances
docker stop postgresql
docker rm postgresql

# run container
docker run -d \
  -e POSTGRESQL_DATABASE=mydb \
  -e POSTGRESQL_USERNAME=myuser \
  -e POSTGRESQL_PASSWORD=mypass \
  -p 5432:5432 \
  -v /opt/docker/postgresql/etc:/etc/postgresql/9.5/main \
  -v /opt/docker/postgresql/lib:/var/lib/postgresql/9.5/main \
  -v /opt/docker/postgresql/log:/var/log/postgresql \
  --name postgresql \
  madharjan/docker-postgresql:9.5

Systemd Unit File

Note: update environment variables below as necessary

[Unit]
Description=PostgreSQL Server

After=docker.service

[Service]
TimeoutStartSec=0

ExecStartPre=-/bin/mkdir -p /opt/docker/postgresql/etc
ExecStartPre=-/bin/mkdir -p /opt/docker/postgresql/lib
ExecStartPre=-/bin/mkdir -p /opt/docker/postgresql/log
ExecStartPre=-/usr/bin/docker stop postgresql
ExecStartPre=-/usr/bin/docker rm postgresql
ExecStartPre=-/usr/bin/docker pull madharjan/docker-postgresql:9.5

ExecStart=/usr/bin/docker run \
  -e POSTGRESQL_DATABASE=mydb \
  -e POSTGRESQL_USERNAME=myuser \
  -e POSTGRESQL_PASSWORD=mypass \
  -p 5432:5432 \
  -v /opt/docker/postgresql/etc:/etc/postgresql/etc/9.5/main \
  -v /opt/docker/postgresql/lib:/var/lib/postgresql/9.5/main \
  -v /opt/docker/postgresql/log:/var/log/postgresql \
  --name postgresql \
  madharjan/docker-postgresql:9.5

ExecStop=/usr/bin/docker stop -t 2 postgresql

[Install]
WantedBy=multi-user.target

Generate Systemd Unit File

Variable	Default	Example
PORT		5432
VOLUME_HOME	/opt/docker	/opt/data
NAME	postgresql	docker-postgresql
POSTGRESQL_DATABASE	postgres	mydb
POSTGRESQL_USERNAME	postgres	user
POSTGRESQL_PASSWORD		pass

# generate postgresql.service
docker run --rm \
  -e PORT=5432 \
  -e NAME=docker-postgresql \
  -e POSTGRESQL_PASSWORD=pass \
  madharjan/docker-postgresql:9.5 \
  postgresql-systemd-unit | \
  sudo tee /etc/systemd/system/postgresql.service

sudo systemctl enable postgresql
sudo systemctl start postgresql