This repository contains a Docker image for the OpenHSV Postgres database. This image is an extension of Docker's official postgres image with start-up seed file for initializing the database (also called postgres) with dummy data.
# build container image and assign name
docker build -t openhsv-db:1.0.0 .
# run container (uses seed.sql to populate db)
OPENHSV_CID=$(docker run --name openhsv-db -d -e POSTGRES_PASSWORD=password openhsv-db:1.0.0)
# connect to openhsv-db container in psql shell (may need to wait a few seconds)
docker run -it --rm --link openhsv-db:postgres postgres psql -h postgres -U postgres
# test query
postgres=# SELECT * from categories;Optionally, you could connect via the Bash shell...
# connect to openhsv-db container in bash shell
docker exec -it ${OPENHSV_CID} /bin/bash
# open of psql shell within openhsv-db container
psql -U postgresFirst, remove/comment the COPY command in the Dockerfile to inhibit the automatic import:
FROM postgres:latest
# (other commands)
# COPY ./seed.sql /docker-entrypoint-initdb.d/seed.sql
Then, take the following steps...
# build container image and assign name
docker build -t openhsv-db-debug:1.0.0 .
# mount local seed.sql file to the container's root directory
OPENHSV_DEBUG_CID=$(docker run --name openhsv-db-debug -d -v $(pwd)/seed.sql:/seed.sql -e POSTGRES_PASSWORD=password openhsv-db-debug:1.0.0)
# connect to openhsv-db-debug container in bash shell
docker exec -it ${OPENHSV_DEBUG_CID} /bin/bash
# attempt import of seed.sql file and look for errors
psql -U postgres -f seed.sqlAlso, if you end up creating a bunch of containers you want to remove, then you can always run the following commands:
# stop and remove all containers
docker stop $(docker ps -a -q)
docker rm $(docker ps -a -q)
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent