docker-postgres.service

# @file /etc/systemd/system/docker-postgres.service
# @see https://docs.docker.com/articles/host_integration/

[Unit]
Description=postgres container
Requires=docker.service
After=docker.service

[Service]
Restart=always
ExecStart=/usr/bin/docker start -a postgres
ExecStop=/usr/bin/docker stop -t 60 postgres

[Install]
WantedBy=multi-user.target

how-to-control-postgres-container.sh

# start container
sudo systemctl start docker-postgres

# stop container
sudo systemctl stop docker-postgres

# attach shell to container
docker exec -it postgres bash

# start psql connection
docker exec -it postgres psql -h postgres -U postgres

# dump a database
docker exec postgres pg_dump -h postgres -U postgres ${table}

# see the logs
docker logs postgres

# for more see
# https://hub.docker.com/_/postgres/
# https://docs.docker.com/articles/host_integration/

prepare.sh

# create config and data directory
mkdir -p $HOME/docker/postgres/data

# initially create the docker container
docker run --restart=on-failure:5 \
           --volume=$HOME/docker/postgres/data:/var/lib/postgresql/data \
           --env=POSTGRES_PASSWORD=secret \
           --publish=5432:5432 \
           --hostname=postgres \
           --name=postgres \
           --detach=true \
           postgres:latest