title: Postgres does not init the database in docker
body: <p>I'm trying to create a new postgres database. </p>
  
  <p>Just for starters - creating a new volume:</p>
  
  <pre><code>docker volume create test
  </code></pre>
  
  <p>And then starting the image. </p>
  
  <pre><code>docker run  -v test:/var/lib/postgresql/data -p 5432:5432 nec-postgres
  </code></pre>
  
  <p>Now here is my Dockerfile:</p>
  
  <pre><code>FROM postgres:10.4
  
  ENV POSTGRES_USER=user
  ENV POSTGRES_PASSWORD=pass
  ENV POSTGRES_DB=smdr
  
  COPY *.sql /docker-entrypoint-initdb.d/
  </code></pre>
  
  <p>Looks simple, and according to <a href="https://hub.docker.com/_/postgres/" rel="nofollow noreferrer">https://hub.docker.com/_/postgres/</a> suppose to create a database, and run the init scripts on that database if the volume is empty.</p>
  
  <p>When I'm starting my image first time I'm getting as expected: </p>
  
  <pre><code>/usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/1_database.sql
  CREATE TABLE
  CREATE TABLE
  CREATE TABLE
  CREATE TABLE
  ALTER TABLE
  ALTER TABLE
  ALTER TABLE
  ALTER TABLE
  </code></pre>
  
  <p>After the init I'm seeing (again, as expected)</p>
  
  <pre><code>2018-06-05 06:55:51.855 UTC [37] LOG:  received fast shutdown request
  waiting for server to shut down....
  2018-06-05 06:55:51.859 UTC [37] LOG:  aborting any active transactions
  2018-06-05 06:55:51.863 UTC [37] LOG:  worker process: logical replication launcher (PID 44) exited with exit code 1
  2018-06-05 06:55:51.864 UTC [39] LOG:  shutting down
  2018-06-05 06:55:51.904 UTC [37] LOG:  database system is shut down
   done
  server stopped
  
  PostgreSQL init process complete; ready for start up.
  
  2018-06-05 06:55:51.971 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
  2018-06-05 06:55:51.972 UTC [1] LOG:  listening on IPv6 address "::", port 5432
  2018-06-05 06:55:51.978 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
  2018-06-05 06:55:51.993 UTC [109] LOG:  database system was shut down at 2018-06-05 06:55:51 UTC
  2018-06-05 06:55:52.000 UTC [1] LOG:  database system is ready to accept connections
  </code></pre>
  
  <p>Now, no matter what I do my database is empty. I'm not seeing any tables or any data in the database once I connect to it. </p>
  
  <p>I tried with both 10.4 and 10.4-alpine, I tried 9.6-alpine but can't seem to make that thing work. </p>
  
  <p>I Would appreciate any suggestions. </p>
  
  <p><hr>
  <strong>Update #1:</strong></p>
  
  <p>Here is the full startup log for postgres:</p>
  
  <pre><code>root@smdr:/home/smdr/nec# docker logs smdr_nec-postgres.ytyrdw0r2j76aytclj3d9tusj.0vd91n153gxeydsbjp730tlvj
  The files belonging to this database system will be owned by user "postgres".
  This user must also own the server process.
  
  The database cluster will be initialized with locale "en_US.utf8".
  The default database encoding has accordingly been set to "UTF8".
  The default text search configuration will be set to "english".
  
  Data page checksums are disabled.
  
  fixing permissions on existing directory /var/lib/postgresql/data ... ok
  creating subdirectories ... ok
  selecting default max_connections ... 100
  selecting default shared_buffers ... 128MB
  selecting dynamic shared memory implementation ... posix
  creating configuration files ... ok
  running bootstrap script ... ok
  performing post-bootstrap initialization ... ok
  syncing data to disk ... ok
  
  WARNING: enabling "trust" authentication for local connections
  You can change this by editing pg_hba.conf or using the option -A, or
  --auth-local and --auth-host, the next time you run initdb.
  
  Success. You can now start the database server using:
  
      pg_ctl -D /var/lib/postgresql/data -l logfile start
  
  waiting for server to start....2018-06-05 16:00:25.543 UTC [37] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
  2018-06-05 16:00:25.560 UTC [38] LOG:  database system was shut down at 2018-06-05 16:00:25 UTC
  2018-06-05 16:00:25.566 UTC [37] LOG:  database system is ready to accept connections
   done
  server started
  CREATE DATABASE
  
  CREATE ROLE
  
  
  /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/1_database.sql
  CREATE TABLE
  CREATE TABLE
  CREATE TABLE
  CREATE TABLE
  CREATE TABLE
  CREATE TABLE
  CREATE TABLE
  CREATE TABLE
  ALTER TABLE
  ALTER TABLE
  ALTER TABLE
  ALTER TABLE
  ALTER TABLE
  ALTER TABLE
  ALTER TABLE
  ALTER TABLE
  
  
  /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/2_indexes.sql
  CREATE INDEX
  CREATE INDEX
  CREATE INDEX
  CREATE INDEX
  CREATE INDEX
  CREATE INDEX
  
  
  /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/3_init.sql
  INSERT 0 1
  INSERT 0 1
  INSERT 0 1
  
  
  /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/4_functions.sql
  CREATE FUNCTION
  
  
  /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/5_roles.sql
  
  
  2018-06-05 16:00:26.551 UTC [37] LOG:  received fast shutdown request
  waiting for server to shut down....2018-06-05 16:00:26.555 UTC [37] LOG:  aborting any active transactions
  2018-06-05 16:00:26.558 UTC [37] LOG:  worker process: logical replication launcher (PID 44) exited with exit code 1
  2018-06-05 16:00:26.559 UTC [39] LOG:  shutting down
  2018-06-05 16:00:26.612 UTC [37] LOG:  database system is shut down
   done
  server stopped
  
  PostgreSQL init process complete; ready for start up.
  
  2018-06-05 16:00:26.671 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
  2018-06-05 16:00:26.672 UTC [1] LOG:  listening on IPv6 address "::", port 5432
  2018-06-05 16:00:26.679 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
  2018-06-05 16:00:26.697 UTC [109] LOG:  database system was shut down at 2018-06-05 16:00:26 UTC
  2018-06-05 16:00:26.703 UTC [1] LOG:  database system is ready to accept connections
  </code></pre>