Skip to content

Instantly share code, notes, and snippets.

@RyAndrew
Forked from jkatz/setup.sh
Created May 5, 2019 20:49
Show Gist options
  • Save RyAndrew/e29beab12723cf9eeb84083e0a564a1d to your computer and use it in GitHub Desktop.
Save RyAndrew/e29beab12723cf9eeb84083e0a564a1d to your computer and use it in GitHub Desktop.
Install PostgreSQL 10 & pgAdmin 4 with Docker
#!/bin/bash
mkdir postgres
cd postgres
docker volume create --driver local --name=pgvolume
docker volume create --driver local --name=pga4volume
docker network create --driver bridge pgnetwork
cat << EOF > pg-env.list
PG_MODE=primary
PG_PRIMARY_USER=postgres
PG_PRIMARY_PASSWORD=yoursecurepassword
PG_DATABASE=testdb
PG_USER=yourusername
PG_PASSWORD=yoursecurepassword
PG_ROOT_PASSWORD=yoursecurepassword
PG_PRIMARY_PORT=5432
EOF
cat << EOF > pgadmin-env.list
[email protected]
PGADMIN_SETUP_PASSWORD=yoursecurepassword
SERVER_PORT=5050
EOF
docker run --publish 5432:5432 \
--volume=pgvolume:/pgdata \
--env-file=pg-env.list \
--name="postgres" \
--hostname="postgres" \
--network="pgnetwork" \
--detach \
crunchydata/crunchy-postgres:centos7-11.2-2.3.1
docker run --publish 5050:5050 \
--volume=pga4volume:/var/lib/pgadmin \
--env-file=pgadmin-env.list \
--name="pgadmin4" \
--hostname="pgadmin4" \
--network="pgnetwork" \
--detach \
crunchydata/crunchy-pgadmin4:centos7-11.2-2.3.1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment