Dockerを利用したPostgreSQLの環境構築

FROM postgres:11-alpine
ENV LANG ja_JP.utf8
RUN mkdir /var/lib/postgres/data/sample-db

version: '3'
services:
  db:
    container_name: postgres
    build: .
    ports:
      - 5433:5432
    volumes:
      - ./db:/var/lib/postgresql/data
      - ./sample-db:/var/lib/postgresql/data/sample-db
    environment:
      POSTGRES_USER: admin
      POSTGRES_PASSWORD: admin

$ docker-compose build
$ docker-compose up

$ docker exec -it postgres bash

# psql -U admin

CREATE DATABASE dvdrental

$ pg_restore -U admin -d dvdrental /var/lib/postgresql/data/sample-db/dvdrental.tar

\c dvdrental

dvdrental=# \dt
           List of relations
 Schema |     Name      | Type  | Owner
--------+---------------+-------+-------
 public | actor         | table | admin
 public | address       | table | admin
 public | category      | table | admin
 public | city          | table | admin
 public | country       | table | admin
 public | customer      | table | admin
 public | film          | table | admin
 public | film_actor    | table | admin
 public | film_category | table | admin
 public | inventory     | table | admin
 public | language      | table | admin
 public | payment       | table | admin
 public | rental        | table | admin
 public | staff         | table | admin
 public | store         | table | admin
(15 rows)