Skip to content

Instantly share code, notes, and snippets.

@emis44
Last active October 25, 2020 17:09
Show Gist options
  • Save emis44/ea0fc406257f7ffeb72124a3350acb7c to your computer and use it in GitHub Desktop.
Save emis44/ea0fc406257f7ffeb72124a3350acb7c to your computer and use it in GitHub Desktop.
[Docker] docker da ricordare #docker
-- install docker image end start container
docker run -p 5432:5432 --name postgrespagopa -e POSTGRES_PASSWORD=pagopa -d postgres:10.12
-- dump db
pg_dump -F c -f /home/escampoli/pagopa01052020.tar.gz -U pagopa -h localhost -p 5432 pagopa
-- copio dump del db
docker cp /dumpdb.tar.gz postgrespagopa:/docker-entrypoint-initdb.d/dumpdb.tar.gz
--connect to postgres 10.12
docker exec -it postgrespagopa psql -U postgres
-- create pagopa and scheme
CREATE DATABASE pagopa WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';
CREATE SCHEMA etl;
-- exit drom psql
\q
-- connect to pagopa
docker exec -it postgrespagopa psql -U postgres pagopa
-- importo dump db pagopa
docker exec -it postgrespagopa pg_restore -d pagopa /docker-entrypoint-initdb.d/pagopadump.tar.gz -U postgres -F c
// FINE
ngix che serve la cartella /Users/emis/Documents/progetti/DOCKER/html:/usr/share/nginx/html
docker run -d --name nginx-latest -p 80:80 -v "/Users/emis/Documents/progetti/DOCKER/html:/usr/share/nginx/html" nginx:latest
// FINE
-- doc
https://docs.docker.com/engine/reference/commandline/
-- tutti i container (anche quelli stoppati)
docker container ls --all
-- ls containers attivi
docker container ls
-- running containers
docker ps
-- stop container by id
docker container stop eb6aeb54a4a7
-- rm container
docker container rm eb6aeb54a4a7
-- image ls
docker image ls
-- rm image
docker rmi b500168be260
-- bash into container
docker exec -it f91924975c6d bash
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment