PostgreSQL and Docker - getting started

Описание: Tutorial and demo to show you how you can start using Postgres docker containers

Video agenda : PostgreSQL with Docker
AGENDA
-------

1 : Create a Postgres docker container
docker run --name demo -e POSTGRES_PASSWORD=password1 -d postgres


2: Connect and run some queries
docker exec -it demo psql -U postgres

CREATE DATABASE demo_db1
\c demo_db1
CREATE TABLE demo_t(something int);
INSERT INTO demo_t (something) VALUES (1);


3: Automate - run scripts using docker cli
run sql scripts from your host machine/dev machine etc

docker run --name demo -v "$PWD"/:/opt/demo/ -e POSTGRES_PASSWORD=password1 -d postgres
docker exec -it demo psql -U postgres -c "CREATE DATABASE demo_db2"
docker exec -it demo psql -U postgres -f /opt/demo/script_demo1.sql