Running Postgresql on Docker

Описание: //Create the postgres db inside docker
docker run --name POSTGRES_CONTAINER -e POSTGRES_USER=username -e POSTGRES_PASSWORD=password -p 5432:5432 -v /data:/var/lib/postgresql/data -d postgres

//Connect to the db with psql
docker exec -it 23730892234a psql -U username -W postgres

//Create the database
CREATE DATABASE dvdrental;

//Copy the data into the container
docker cp /home/javingvm/Downloads/dvdrental.tar POSTGRES_CONTAINER:dvdrental.tar

//Load the data into the db
docker exec -it POSTGRES_CONTAINER pg_restore -U username -d dvdrental dvdrental.tar (e

The data used for this video can be found here:
www.postgresqltutorial.com/postgresql-getting-started/postgresql-sample-database/