Many developers still install a database on their computer and work on it. It may be a preferable method, but using Docker takes only seconds to set up a database. I used and in my latest project. As a result, I have achieved efficiency and convenience. I will give you my experience with PostgreSQL and Docker. PostgreSQL Docker I can start with finding the Docker image we will use. There are two easy ways to do this. I prefer to visit the website. Alternatively, it can be used the command below. It will list you similar results to the Docker Hub. Docker Hub docker search postgresql I will use the , the official image can be obtained in the search results. I prepared a Docker command with important and necessary parameters. It can be easily customized and used this command. postgres docker run --name postgresqldb -e POSTGRES_USER=myusername -e POSTGRES_PASSWORD=mypassword -p 5432:5432 -v /data:/var/lib/postgresql/data -d postgres It looks a little confused, but don't worry. I will explain these parameters. I set a name for the container. --name : I set the database username. -e POSTGRES_USER : I set the database password. -e POSTGRES_PASSWORD : 5432 port is used by default. But it can be changed this according to preference. Local port and container port can be set separately. The first port is for local, and the second is for container. -p : This parameter is related to the Docker Volume feature. This is important for not losing data. With this feature, I synchronize with the folder containing the data in the database and a folder of my choice on the computer or server. When the container is closed or restarted for any reason, it can be easily started with the same data. The first path can be any folder you prefer. I set it to as an example. Please do not change the second path because data is in this path by default. -v : /data I will run detached mode(background mode). If you run it without using it, the docker container will be stopped when you press the Ctrl + C combination or close the terminal screen. This is undesirable because the container should be running in the background. -d : : Image name. postgres Let's run the command together and see the result. If you have encountered a similar output, you can be sure that everything is fine. You can see the working Docker containers by running the command below. docker ps You can also stop or restart your container using start and stop commands. In this example I set the container name as postgresqldb. You can run the start and stop commands with your own chosen name. docker start postgresqldb
docker stop postgresqldb You may think it took a long time because I explained the details. Don't be biased, you can create a PostgreSQL database just by running a single Docker command.

coding...

Read My Stories

Too Long; Didn't Read

In your car, at home, or at work — Bosch technology shapes many areas of life.

How To Install PostgreSQL With Docker Quickly

Too Long; Didn't Read

Çağatay Özata

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

How To Install PostgreSQL With Docker Quickly

Too Long; Didn't Read

Çağatay Özata

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

RELATED STORIES