Â
When utilizing Docker, you need to use volumes to persist knowledge even once you cease or restart the containers. We’ll create and use Docker volumes for PostgreSQL.
Stipulations
Â
To observe together with this tutorial:
- You need to have Docker put in in your machine
- You have to be snug with Docker instructions and PostgreSQL
Â
Step 1: Pull the PostgreSQL Picture
Â
First, we pull the PostgreSQL picture from DockerHub:
Â
Step 2: Create a Docker Quantity
Â
Subsequent, let’s create a Docker quantity to retailer the information. This quantity will persist the information even when the container is eliminated.
$ docker quantity create pg_data
Â
Step 3: Run the PostgreSQL Container
Â
Now that we’ve pulled the picture and created a quantity, we are able to run the PostgreSQL container attaching the created quantity to it.
$ docker run -d
--name my_postgres
-e POSTGRES_PASSWORD=mysecretpassword
-v pg_data:/var/lib/postgresql/knowledge
-p 5432:5432
postgres
Â
This command runs my_postgres
in indifferent mode. Utilizing –v pg_data:/var/lib/postgresql/knowledge mounts the pg_data
quantity to /var/lib/postgresql/knowledge within the container. And utilizing -p 5432:5432 maps port 5432 of my_postgres
to port 5432 on the host machine.
Â
Step 4: Confirm the Quantity Utilization
Â
Now that we’ve created the amount, we are able to confirm it’s getting used. You may examine the amount and verify the contents.
$ docker quantity examine pgdata
Â
Operating this command will present particulars in regards to the quantity, together with its mount level in your host system. You may navigate to this listing and see the PostgreSQL knowledge recordsdata.
[
{
"CreatedAt": "2024-08-07T15:53:23+05:30",
"Driver": "local",
"Labels": null,
"Mountpoint": "/var/lib/docker/volumes/pg_data/_data",
"Name": "pg_data",
"Options": null,
"Scope": "local"
}
]
Â
Step 5: Create a Database and Desk
Â
Hook up with the Postgres occasion and create a database and desk.
Begin a psql session:
$ docker exec -it my_postgres psql -U postgres
Â
Create a brand new database:
Â
Hook up with the brand new database:
Â
Create a desk and insert some knowledge:
CREATE TABLE customers (
id SERIAL PRIMARY KEY,
identify VARCHAR(100),
electronic mail VARCHAR(100)
);
INSERT INTO customers (identify, electronic mail) VALUES ('Abby', 'abby@instance.com'), ('Bob', 'bob@instance.com');
Â
Run a pattern question:
Â
Output:
id | identify | electronic mail
----+------+------------------
1 | Abby | abby@instance.com
2 | Bob | bob@instance.com
Â
Step 6: Cease and Take away the Container
Â
Cease the operating container and take away it. We do that so we are able to check that the information persists even when the container is stopped.
$ docker cease my_postgres
$ docker rm my_postgres
Â
Â
Step 7: Re-run the Postgres Container with the Identical Quantity
Â
Begin a brand new PostgreSQL container with the identical quantity to make sure knowledge persistence.
$ docker run -d
--name my_postgres
-e POSTGRES_PASSWORD=mysecretpassword
-v pgdata:/var/lib/postgresql/knowledge
-p 5432:5432
postgres
Â
Hook up with the Postgres occasion and confirm that the information persists.
Open a psql session:
$ docker exec -it my_postgres psql -U postgres
Â
Hook up with the mydb
database:
Â
Confirm the information within the customers
desk:
Â
You need to nonetheless see the output:
id | identify | electronic mail
----+------+------------------
1 | Abby | abby@instance.com
2 | Bob | bob@instance.com
Â
I hope this tutorial helps you perceive find out how to use volumes to persists knowledge when working with Docker.
Â
Further Sources
Â
To be taught extra, learn the next assets:
Completely satisfied exploring!
Â
Â
Bala Priya C is a developer and technical author from India. She likes working on the intersection of math, programming, knowledge science, and content material creation. Her areas of curiosity and experience embody DevOps, knowledge science, and pure language processing. She enjoys studying, writing, coding, and occasional! At the moment, she’s engaged on studying and sharing her information with the developer group by authoring tutorials, how-to guides, opinion items, and extra. Bala additionally creates participating useful resource overviews and coding tutorials.