title: Dockerizing PostgreSQL - psql Connection refused
body: <p>I'm playing around with Docker and I would like to Dockerize a Postgres container.</p>
  
  <p>I'm following the official <a href="http://docs.docker.com/examples/postgresql_service/" rel="noreferrer">example</a> but I can not connect to the image running using psql.</p>
  
  <p>I created the Dockerfile with the content of the example. I builded an image from the Dockerfile and assigned it a name. Then I run the PostgreSQL server container (in the foreground).</p>
  
  <pre><code>~/test » docker run --rm -P --name pg_test eg_postgresql                                                                                                       
  2014-10-10 06:12:43 UTC LOG:  database system was interrupted; last known up at 2014-10-10 06:12:29 UTC
  2014-10-10 06:12:43 UTC LOG:  database system was not properly shut down; automatic recovery in progress
  2014-10-10 06:12:43 UTC LOG:  redo starts at 0/1782F68
  2014-10-10 06:12:43 UTC LOG:  record with zero length at 0/1782FA8
  2014-10-10 06:12:43 UTC LOG:  redo done at 0/1782F68
  2014-10-10 06:12:43 UTC LOG:  last completed transaction was at log time 2014-10-10 06:12:29.2487+00
  2014-10-10 06:12:43 UTC LOG:  database system is ready to accept connections
  2014-10-10 06:12:43 UTC LOG:  autovacuum launcher started
  </code></pre>
  
  <p>Then I open another terminal to find out the port:</p>
  
  <pre><code>~/test » docker ps                                                                                                                                             
  CONTAINER ID        IMAGE                  COMMAND                CREATED             STATUS              PORTS                     NAMES
  aaedb0479139        eg_postgresql:latest   "/usr/lib/postgresql   3 days ago          Up 41 seconds       0.0.0.0:49154-&gt;5432/tcp   pg_test
  </code></pre>
  
  <p>So I can use psql to connect to the instance. But I can't...</p>
  
  <pre><code>~/test » psql -h localhost -p 49154 -d docker -U docker --password                                                                                             
  Password for user docker:
  psql: could not connect to server: Connection refused
      Is the server running on host "localhost" (127.0.0.1) and accepting
      TCP/IP connections on port 49154?
  could not connect to server: Connection refused
      Is the server running on host "localhost" (::1) and accepting
      TCP/IP connections on port 49154?
  could not connect to server: Connection refused
      Is the server running on host "localhost" (fe80::1) and accepting
      TCP/IP connections on port 49154?
  </code></pre>
  
  <p>Any help is appreciated.</p>