docker-postgresql-client

Features

PostgreSQL Client 9.5 (docker-postgresql-client)

Environment

Build

# clone project
git clone https://github.com/madharjan/docker-postgresql-client
cd docker-postgresql-client
# build
make
# tests
make run
make test
# clean
make clean

Run

Postgres Server (docker-postgresql)

# stop & remove previous instances
docker stop postgresql
docker rm postgresql
# run container
docker run -d \
 -e POSTGRESQL_PASSWORD=mypass \
 --name postgresql \
 madharjan/docker-postgresql:9.5

Postgres Client (docker-postgresql-client)

# psql console
docker run --rm -it \
 --link postgresql:db \
 -e POSTGRESQL_HOST=db \
 -e POSTGRESQL_PASSWORD=mypass \
 madharjan/docker-postgresql-client:9.5
# psql script
docker run --rm -it \
 --link postgresql:db \
 -e POSTGRESQL_HOST=db \
 -e POSTGRESQL_PASSWORD=mypass \
 madharjan/docker-postgresql-client:9.5 \
 -c 'select user from user'

Cleanup

docker stop postgresql
docker rm postgresql