Dockerfile

FROM postgres:9.3-alpine

# Build scratch.sql by running:
# $ pg_dump --no-owner --no-acl scratch > scratch.sql.gz
COPY scratch.sql /docker-entrypoint-initdb.d/

snippets.sh

# Change to gist directory
cd /path/to/scratch-pg93

# Build the Image
docker build -t scratch-pg93 .

# Start PG server listening to 25432
docker run -it --rm -p 25432:5432 scratch-pg93

# List table
docker run -it --rm scratch-pg93 psql -h docker.for.mac.localhost -p 25432 -U postgres -c '\d'

# Connect to it
docker run -it --rm scratch-pg93 psql -h docker.for.mac.localhost -p 25432 -U postgres

# docker.for.mac.localhost can be changed to localhost on Linux hosts.
docker run -it --rm scratch-pg93 psql -h localhost -p 25432 -U postgres