PostgreSQL and Docker - getting started
Автор: Melvin L
Загружено: 2018-02-13
Просмотров: 70648
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
