How to Run PostgreSQL in Docker?

How to Run PostgreSQL in Docker

PostgreSQL is an open-source relational database management system that has become increasingly popular among developers due to its powerful features and scalability. Docker, on the other hand, is a containerization platform that allows developers to package applications and their dependencies into containers, making them portable and easy to deploy.

In this article, we will explore how to run PostgreSQL in Docker, step by step.

Prerequisites

To follow this tutorial, you should have the following prerequisites installed on your machine:

  • Docker
  • A basic understanding of PostgreSQL

Step 1: Pull the PostgreSQL Image

The first step in running PostgreSQL in Docker is to pull the PostgreSQL image from the Docker Hub. You can do this by running the following command:

docker pull postgres

This command will download the latest version of the PostgreSQL image from the Docker Hub.

Step 2: Start a PostgreSQL Container

After pulling the PostgreSQL image, the next step is to start a container from the image. You can do this by running the following command:

docker run --name postgres-container -e POSTGRES_PASSWORD=mysecretpassword -d postgres

This command will start a new container named "postgres-container" with the specified environment variable for the PostgreSQL password. The "-d" flag is used to run the container in detached mode, which means that the container will run in the background.

Step 3: Connect to the PostgreSQL Container

Now that the PostgreSQL container is running, you can connect to it using a PostgreSQL client. One way to do this is by running another container with a PostgreSQL client image, such as psql. You can do this by running the following command:

docker run -it --rm --link postgres-container:postgres postgres psql -h postgres -U postgres

This command will start a new container with the psql image and link it to the running PostgreSQL container. You will then be prompted to enter the PostgreSQL password you set in the previous step.

Step 4: Create a Database

After connecting to the PostgreSQL container, you can create a new database by running the following SQL command:

CREATE DATABASE mydatabase;

This command will create a new database named "mydatabase".

Step 5: Use the Database

To use the newly created database, you can connect to it by running the following SQL command:

\c mydatabase

This command will connect you to the "mydatabase" database.

Step 6: Exit the Container

After you are done using the PostgreSQL container, you can exit the container by running the following command:

exit

This command will exit the PostgreSQL client container and return you to your host machine's command prompt.

So, running PostgreSQL in Docker is a straightforward process that requires only a few simple steps. By following the steps outlined in this tutorial, you can quickly get up and running with a PostgreSQL container and start working with PostgreSQL databases.

Related Searches and Questions asked:

  • How to Dockerize Postgres?
  • How to Create PostgreSQL Database with Docker?
  • How to Mount Docker Volume to PostgreSQL Container?
  • How to Pull PostgreSQL Image from Docker Hub?
  • That's it for this post. Keep practicing and have fun. Leave your comments if any.

    Post a Comment

    0 Comments