Running DB from a dump in seconds
I will take this free dataset from postgresql website.
docker run -d --name my_db \
-v /Users/nolan/Downloads/french-towns-communes-francaises-1.0/french-towns-communes-francaises.sql:/docker-entrypoint-initdb.d/create_table.sql \
-p 54320:5432 -e POSTGRES_PASSWORD=my_password -e POSTGRES_USER=nolan postgres
Connect to DB
pgcli -h localhost -p54320 -Unolan
nolan@localhost:nolan> SELECT count(*) FROM towns where name like 'Mont%';
Result:
count |
---|
826 |