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