Config Postgres

## POSTGRES DATABASE

docker run -it
-e POSTGRES_USER="*"
-e POSTGRES_PASSWORD="*"
-e POSTGRES_DB="ny_taxi"
-v ~/2_docker_sql/ny_taxi_postgres_data:/var/lib/postgresql/data
-p 5432:5432 postgres:16

## POSTGRES CLI INTERFACE

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

## PGADMIN WEB-INTERFACE

docker run -it \
-e PGADMIN_DEFAULT_EMAIL="*" \
-e PGADMIN_DEFAULT_PASSWORD="*" \
-p 8080:80 \
--network=pg-network \
--name pgadmin4 \
dpage/pgadmin4

## DOCKER NETWORK

docker network create pg-network

# POSTGRES DATABASE WITH NETWORK

docker run -it \
-e POSTGRES_USER="*" \
-e POSTGRES_PASSWORD="*" \
-e POSTGRES_DB="ny_taxi" \
-v ~/2_docker_sql/ny_taxi_postgres_data:/var/lib/postgresql/data \
-p 5432:5432 \
--network=pg-network \
--name pg-database \
postgres:16