pgDocker

Postgres docker

Docker for postgres.

The only significant change from default image is that image is run as local user postgres

Installation

Create user postgres on host machine (assuming local PC is not running postgres, if so, use local installation).

sudo adduser postgres
sudo su postgres
git clone pgDocker
cd pgDocker

Go to pgDocker/bin directory, copy env.sh.sample to env.sh and correct environment variables, particularly $PGPASS and $DOCKERCOMPOSE so they point to the correct files.

Run start.sh

pgDocker/bin/start.sh

And you should be able to connect via

psql -p 5432 -h 127.0.0.1 -u postgres

Type the password set in $PGPASS to access the database.