记录Zoomcamp从0开启ny_taxi表的步骤

打开Docker desktop

打开git bash运行postgres:13

在 /h/data-engineering-zoomcamp/01-docker-terraform/2_docker_sql路径下执行

docker run -it \
  -e POSTGRES_USER="root" \
  -e POSTGRES_PASSWORD="root" \
  -e POSTGRES_DB="ny_taxi" \
  -v "h:\data-engineering-zoomcamp\01-docker-terraform\2_docker_sql\ny_taxi_postgres_data:/var/lib/postgresql/data" \
  -p 5432:5432 \
  postgres:13

打开PowerShell

在 /h/data-engineering-zoomcamp/01-docker-terraform/2_docker_sql路径下执行

pgcli -h localhost -p 5432 -u root -d ny_taxi

DONE.