/dvdrental-pgadmin-docker

This repository allows for easy setup of http://www.postgresqltutorial.com/

Primary LanguageShell

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