Set up a throw-away postgresql server in docker and a client to connect to it

postgres-sandbox.sh

#!/bin/bash

docker pull postgres:11-alpine

docker network inspect postgres_sandbox  > /dev/null 2>&1
if [[ "$?" == "0" ]]; then
    docker network rm postgres_sandbox
fi
docker network create --driver bridge postgres_sandbox

docker run -d --name postgres_server --network postgres_sandbox --health-cmd='pg_isready' -e POSTGRES_PASSWORD=s3cr3t postgres:11-alpine
printf "Waiting for Postgres to start"
while [ $(docker inspect --format "{{json .State.Health.Status }}" postgres_server) != "\"healthy\"" ]; do
    printf "."
    sleep 1
done
printf "\nServer started. Connecting.\n"
docker run -it --rm --name postgres_client --network postgres_sandbox -e PGPASSWORD=s3cr3t postgres:11-alpine psql -h postgres_server -U postgres
docker stop postgres_server && docker rm postgres_server
docker network rm postgres_sandbox