[VPS Docker] Docker PostgreSQL

Docker PostgreSQL

💡 Docker PostgreSQL 설치 방법 안내

 

1. VPS 접속

ssh -i <SSH Key name> root@**.**.***.***

2. PostgreSQL Docker volume 생성

docker volume create <Docker volume name>

3. Docker PostgreSQL12 image 및 컨테이너 실행

• docker compose로 최초 컨테이너 생성 시 postgres 비밀번호 이슈 발생
• 사용자, 비밀번호, Database가 자동설정된다.

docker run -d \\
  --name <PostgreSQL Docker 컨테이너 이름> \\
  --network <Docker network name> \\
  -e POSTGRES_USER=<사용자> \\
  -e POSTGRES_PASSWORD=<'비밀번호'> \\
  -e POSTGRES_DB=<DB명> \\
  -p 5432:5432 \\
  -v postgresql_data_dev:/var/lib/postgresql/data \\
  postgres:12

 

Docker-Compose.yml

version: '3'

services:
  db:
    image: postgres:12
    container_name: postgres-dev
    volumes:
      - postgresql-data-dev:/var/lib/postgresql/data
    environment:
      - POSTGRES_DB=${DB_NAME}
      - POSTGRES_USER=${DB_USER}
      - POSTGRES_PASSWORD=${DB_PASSWORD}
      - POSTGRES_HOST=${DB_HOST}
      - POSTGRES_PORT=${DB_PORT}
    ports:
      - "5432:5432"
    networks:
      - dev_network
    env_file:
      - .env

volumes:
  postgresql-data-dev: