One day, I shut down my computer, as I usually do nightly. This time, I shut it down on a Friday and turned it back on after a holiday weekend, only to discover that Docker would not start! The Error Everything was fine on the…
Category: containerization
Restoring a SQL Server backup in a Docker container is quite easy. To begin with, you will need persistent storage on your Docker container to follow this blog post. To get that setup, you can follow the instructions in this blog post. I found that…
This is an easy way to retain the data and settings you create and change on your SQL Server Docker instance. There’s a lot of talk about attaching databases after creating your Docker container. I found that you can mount the volumes that SQL Server…
This is a super simple way to retain the data and settings that you create and change on your SQL Server Docker instance. There’s a lot of talk about attaching databases after you recreate your Docker container, but I found that you just have to…
There are three ways to get into bash in a docker container: docker exec -it containername bash docker exec -it containername “bash” docker exec -it containername /bin/bash Once you run those from the command line, it brings you to the top level of the file…
Run psql in docker exec docker exec -ti NAME_OF_CONTAINER psql -U YOUR_POSTGRES_USERNAME
This requires a different image in Docker. You can’t just use the postgres image and create an extension in it. Instead, you have to use the postgis image. This image will have a database in it already setup for you to use with postgis. If…
This is a super simple way to retain the data and settings that you create and change on your PostgreSQL Docker instance. There’s a lot of talk about attaching databases after you recreate your Docker container, but I found that it’s easier to have persistent…
I went to create a container and got an error that it already existed. Hmm, I thought I had removed it. To see all your Docker containers running or not, run this at the command line: I discovered I had a bunch of them hanging…