Skip to content

Latest commit

 

History

History
40 lines (32 loc) · 1.09 KB

README.md

File metadata and controls

40 lines (32 loc) · 1.09 KB

dvdrental-pgadmin-docker

Overview

PostgreSQL playground running on Docker with Pgadmin webinterface. This repo is inspired by

  1. https://github.com/rudibroekhuizen/docker-postgresplus
  2. https://smithjd.github.io/sqlpetr/articles/building-the-dvdrental-docker-image.html
  3. https://github.com/tadaken3/postgres-dvdrental-database-dockerfiles

Usage

Install Docker. Clone this repo to your local machine. Run docker-compose:

docker-compose up

Open pgAdmin Web Interface

http://localhost:5050
  1. Right click on Servers and click Create Server
  2. Name : Docker Postgres DB Server
  3. Check Connect now
  4. Hostname/address : postgres
  5. Port : 5432
  6. Maintenance database : postgres
  7. Password : postgres
  8. Check Save password
  9. Click blue save button
  10. To Run queries, right click on dvdrental under Databases under Docker Postgres DB Server, then click Query Tool

Useful commands

# Check CPU consumption
$ docker stats $(docker inspect -f "{{ .Name }}" $(docker ps -q))

# Remove containers plus volumes
$ docker-compose down -v --remove-orphans --rmi all