asbjornenge/docker-postgresql.md

Forked from zaiste/docker-postgresql.md

Last active December 20, 2015 05:29

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/asbjornenge/6078779.js"></script>
Save asbjornenge/6078779 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

docker-postgresql.md

Docker PostgreSQL How-To

How to use zaiste/postgresql Docker container.

docker pull zaiste/postgresql

CONTAINER=$(docker run -d -p 5432 \
  -t zaiste/postgresql \
  /bin/su postgres -c '/usr/lib/postgresql/9.2/bin/postgres \
    -D /var/lib/postgresql/9.2/main \
    -c config_file=/etc/postgresql/9.2/main/postgresql.conf')

CONTAINER_IP=$(docker inspect $CONTAINER | grep IPAddress | awk '{ print $2 }' | tr -d ',"')

psql -h $CONTAINER_IP -p 5432 -d docker -U docker -W