crzek/learn-sql repository overview

docker run -d --name psql \
    -e POSTGRES_PASSWORD=password \
    -e POSTGRES_DB=airportdb \
    -v $(pwd)"/psql_data:/var/lib/postgresql/data" \
    crzek/learn-sql:1.0

docker exec -it psql psql -U postgres -d airportdb

airportdb=# select * from "aeroport" limit 5;
 codi_aeroport |                   nom                    |  ciutat  |    pais
---------------+------------------------------------------+----------+------------
 BJZ           | Badajoz                                  | Badajoz  | Espanya
 BFS           | Belfast/Aldergrove International Airport | Belfast  | Regne Unit
 SXF           | Berlin-Schönefeld International Airport  | Berlin   | Alemanya
 BLQ           | Aeroporto Guglielmo Marconi              | Bolonia  | Itàlia
 OTP           | Henri Coanda International Airport       | Bucarest | Rumania
(5 rows)

# Use postgres/example user/password credentials
version: '3.9'

services:

  db:
    image: crzek/learn-sql:1.0
    container_name: psql
    restart: always
    # set shared memory limit when using docker-compose
    shm_size: 128mb
    # or set shared memory limit when deploy via swarm stack
    volumes:
      - ./psql_data:/var/lib/postgresql/data
    environment:
      POSTGRES_PASSWORD: {password}
      POSTGRES_DB: {DATABASE}

  adminer:
    image: adminer
    restart: always
    ports:
      - 8080:8080

version: '3.7'
services:
  db:
    image: crzek/learn-sql:1.0
    container_name: psql
    restart: always
    # set shared memory limit when using docker-compose
    shm_size: 128mb
    # or set shared memory limit when deploy via swarm stack
    volumes:
      - ./psql_data:/var/lib/postgresql/data
    environment:
      POSTGRES_PASSWORD: {password}
      POSTGRES_DB: {DATABASE}
    ports:
      - '172.17.0.1:5432:5432'

  pgadmin4:
    image: elestio/pgadmin:REL-8_3
    restart: always
    environment:
      PGADMIN_DEFAULT_EMAIL:{email}
      PGADMIN_DEFAULT_PASSWORD: {password}
      PGADMIN_LISTEN_PORT: 8080
    ports:
      - "172.17.0.1:8080:8080"
    volumes:
      - ./pgadmin_data/servers.json:/pgadmin4/servers.json