db.sh

#!/bin/bash

CONTAINER_NAME=my-postgres-database
VOLUME_NAME="${CONTAINER_NAME}-data"
POSTGRES_PASSWORD=mysecretpassword
POSTGRES_IMAGE=postgres:14


case "$1" in
    start)
        docker run --rm --name "$CONTAINER_NAME" \
               -e POSTGRES_PASSWORD="$POSTGRES_PASSWORD" \
               -d -p 5432:5432 \
               --mount type=volume,src="$VOLUME_NAME",target=/var/lib/postgresql/data \
               "$POSTGRES_IMAGE"
        ;;
    stop)
        docker kill "$CONTAINER_NAME"
        ;;
    connect)
        docker exec -it "$CONTAINER_NAME" psql -U postgres
        ;;
    cleanup)
        docker volume rm "$VOLUME_NAME"
        ;;
    *)
        cat <<EOF
Usage: db.sh <command>

Commands:
    start
        Start docker container in the background
    stop
        Stop docker container
    connect
        Connect to running database server
    cleanup
        Delete docker volume attached to the container
EOF
        ;;
esac