도커로 postgresql 환경 구축

백업을 위한 볼륨

docker volume create pgdata

 

---

 

version: '3'

services:
  postgre_my:
    image: postgres
    container_name: postgre_my
    ports:
      - "8501:5432"
    environment:
      POSTGRES_PASSWORD: mypw
    volumes:
      - pgdata:/var/lib/postgresql/data

  pgadmin:
    image: dpage/pgadmin4
    container_name: pgadmin
    ports:
      - "8080:80"
    environment:
      PGADMIN_DEFAULT_EMAIL: my@test.com
      PGADMIN_DEFAULT_PASSWORD: mypw
    depends_on:
      - postgre_my

 

volumes:
  pgdata:
    external: true

 

---

* pgadmin
http://host_ip:8080/
id : my@test.com
pw : mypw

- new server
Hostname/address: postgre_my
Port: 5432
Maintenance database: postgres
Username: postgres
Password: mypw 

 

파이썬 연결 테스트

import psycopg2

try:
    conn = psycopg2.connect(dbname='postgres', user='postgres', password='mypw', host='127.0.0.1', port='8501')
    cur = conn.cursor()
    cur.execute('SELECT version()')
    print('PostgreSQL version:', cur.fetchone())
except Exception as e:
    print('Error:', e)
finally:
    conn and conn.close()

 

5432 포트를 외부에서 사용시

https://velog.io/@jewon119/TIL135.PostgreSQL-%EC%84%A4%EC%B9%98-%EB%B0%8F-%EC%A0%91%EC%86%8D-%EB%AC%B8%EC%A0%9Cpassword-authentication-failed