docker exec -it <DB_CONTAINER> psql -U <DB_USER> <DB_NAME>
sudo docker exec -it <DB_CONTAINER> pg_dump -U <DB_USER> -t <DB_TABLE> <DB_NAME> > 'path_to_ouput.sql'
docker exec -t <DB_CONTAINER> pg_dumpall -c -U <DB_USER> | gzip > ./tmp/dump_$(date +"%Y-%m-%d_%H_%M_%S").gz
gunzip < your_dump.sql.gz | docker exec -i <DB_CONTAINER> psql -U <DB_USER> -d <DB_NAME>
docker-compose build
docker-compose up
To run the containers in the background
docker-compose up -d
Access to the running machine (mukau-web or any container name, the one defined in docker-compose.yml)
docker exec -it <CONTAINER> bash
docker-compose stop
To stop and remove everything including volumes run (reset). NOTE: This will result in lose of any data save to the database
docker-compose down --volumes
scp -i <path_to_pem_file> <user>@<ip_address>:<path_to_input_file> <path_to_output_directory_location>
UPDATE courses
SET published_date = '2020-08-01'
WHERE course_id = 3;