[Apache Airflow] Airflow DB to Postgres(Docker)

---

Airflow DB to Postgres(Docker)

• 🔗 Airflow Local에 설치 / 🔗 Airflow Docker에 설치
• Postgres Container 설치
• PostgreSQL DB 및 DB User 생성
• airflow.cfg 수정1
• pycopg2-binary 설치
• airflow db 초기화
• airflow.cfg 수정2

---

Postgres Container 설치

# container 생성
docker run -p 5432:5432 --name postgres1 -e POSTGRES_PASSWORD=1234 -d -v psql_data:/var/lib/postgresql/data postgres

# postgres shell 접속
docker exec -it postgres1 bash
su - postgres
psql

---

PostgreSQL DB 및 DB User 생성

• Postgres shell에서 DB 및 DB User 생성

# DB 생성 (CREATE DATABASE [db_name])
CREATE DATABASE airflow_db;

# DB USER 생성 (CREATE USER [id] with password '[password]';)
CREATE USER admin with password 'admin';

# user 생성 확인
\du

---

airflow.cfg 수정1

# airflow.cfg
sql_alchemy_conn = postgresql+psycopg2://admin:admin@localhost/airflow_db

pycopg2-binary 설치

# 가상환경 접속 후
pip3 install psycopg2-binary

---

airflow db 초기화

# airflow db init
airflow db init

# user 생성
airflow users create -u admin -p admin -f jisu -l park -r Admin -e zsu58@korea.ac.kr

# 초기화 확인
docker exec -it postgres1 bash
su - postgres
# psql -U [db_user] [db_name]
psql -U admin -d airflow_db

# 생성된 테이블 확인
\dt

# user 확인
SELECT * FROM ab_user;

---

airflow.cfg 수정2

# airflow.cfg
executor = LocalExecutor

---

ref

• 🔗 참고 블로그