Dockerfile-CentOS7-PG12

#########################################################################
#									#
#    Dockerfile for Fedora PostgreSQL Spin, with PGDG RPM packages.	#
#            Devrim Gündüz <devrim@gunduz.org>				#
#									#
#########################################################################

FROM centos:latest
MAINTAINER devrim@gunduz.org

# Add the PostgreSQL PGP key to verify the official yum repository packages
RUN rpm --import https://yum.postgresql.org/RPM-GPG-KEY-PGDG-12

# Add PostgreSQL's repository. It contains the most recent stable release
# of PostgreSQL, 12:
RUN yum -q -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# Update the Fedora and PostgreSQL repository metadata
RUN yum -q -y install deltarpm
RUN yum -q -y update

# Install PostgreSQL 12 and some useful packages:
RUN yum -q -y install postgresql12-server postgresql12-contrib procps-ng net-tools

# Run the rest of the commands as the postgres user created by the postgresql12-server
# package when it was yum installed
USER postgres

# initdb PostgreSQL 12:
RUN /usr/pgsql-12/bin/initdb -D /var/lib/pgsql/12/data -A trust 2>&1 < /dev/null

# Adjust PostgreSQL configuration so that remote connections to the
# database are possible. 
RUN echo "host all  all    0.0.0.0/0  md5" >> /var/lib/pgsql/12/data/pg_hba.conf

# And add listen_addresses to /var/lib/pgsql/12/data/postgresql.conf
RUN echo "listen_addresses='*'" >> /var/lib/pgsql/12/data/postgresql.conf

# Create a PostgreSQL role named 'docker' with 'docker' as the password and
# then create a database 'docker' owned by the 'docker' role.
# After start, sleep for 5 secs to make sure that postmaster is started before
# creating the role and database:
RUN  /usr/pgsql-12/bin/pg_ctl -D /var/lib/pgsql/12/data start &&\
    sleep 5 &&\
    psql --command "CREATE USER docker WITH SUPERUSER PASSWORD 'docker';" &&\
    createdb -O docker docker

# Expose the PostgreSQL port
EXPOSE 5432

# Add VOLUMEs to allow backup of config, logs and databases
VOLUME  ["/var/lib/pgsql/12"]

# Set the default command to run when starting the container
CMD ["/usr/pgsql-12/bin/postgres", "-D", "/var/lib/pgsql/12/data"]