Created
April 28, 2017 09:26
-
-
Save encoreshao/3859bffca218994bb26a82015f76f150 to your computer and use it in GitHub Desktop.
PostgreSQL 9.6 Dockerfile
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
FROM ubuntu | |
# MAINTAINER email#dot.com | |
# Add the PostgreSQL PGP key to verify their Debian packages. | |
# It should be the same key as https://www.postgresql.org/media/keys/ACCC4CF8.asc | |
RUN apt-key adv --keyserver keyserver.ubuntu.com --recv-keys B97B0AFCAA1A47F044F244A07FCC7D46ACCC4CF8 | |
# Add PostgreSQL's repository. It contains the most recent stable release | |
# of PostgreSQL, ``9.6``. | |
RUN echo "deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main" > /etc/apt/sources.list.d/pgdg.list | |
# Update the Ubuntu and PostgreSQL repository indexes | |
RUN apt-get update && apt-get install -y apt-utils apt-transport-https ca-certificates | |
# Install ``python-software-properties``, ``software-properties-common`` and PostgreSQL 9.6 | |
# There are some warnings (in red) that show up during the build. You can hide | |
# them by prefixing each apt-get statement with DEBIAN_FRONTEND=noninteractive | |
RUN apt-get -y -q install python-software-properties software-properties-common &&\ | |
apt-get -y -q install postgresql-9.6 postgresql-client-9.6 postgresql-contrib-9.6 | |
# Note: The official Debian and Ubuntu images automatically ``apt-get clean`` | |
# after each ``apt-get`` | |
# Run the rest of the commands as the ``postgres`` user created by the ``postgres-9.6`` package when it was ``apt-get installed`` | |
USER postgres | |
# Create a PostgreSQL role named ``docker`` with ``docker`` as the password and | |
# then create a database `docker` owned by the ``docker`` role. | |
# Note: here we use ``&&\`` to run commands one after the other - the ``\`` | |
# allows the RUN command to span multiple lines. | |
RUN /etc/init.d/postgresql start &&\ | |
psql --command "CREATE USER docker WITH SUPERUSER PASSWORD 'docker';" &&\ | |
createdb -O docker docker | |
# Adjust PostgreSQL configuration so that remote connections to the database are possible. and add ``listen_addresses`` to ``/etc/postgresql/9.6/main/postgresql.conf`` | |
RUN echo "host all all 0.0.0.0/0 md5" >> /etc/postgresql/9.6/main/pg_hba.conf &&\ | |
echo "listen_addresses='*'" >> /etc/postgresql/9.6/main/postgresql.conf | |
# Expose the PostgreSQL port | |
EXPOSE 5432 | |
# Add VOLUMEs to allow backup of config, logs and databases | |
VOLUME ["/etc/postgresql", "/var/log/postgresql", "/var/lib/postgresql"] | |
# Set the default command to run when starting the container | |
CMD ["/usr/lib/postgresql/9.6/bin/postgres", "-D", "/var/lib/postgresql/9.6/main", "-c", "config_file=/etc/postgresql/9.6/main/postgresql.conf"] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment